<?xml version='1.0' encoding='ISO-8859-1' standalone='yes'?>
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN' 'http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml' >
<head>
<title>Database documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8"/>
<style type='text/css'>
	 #dbs {font-family:Tahoma,Dialog,Sans-Serif;font-size:11px;background:#fff;width:80%;border-collapse:collapse;text-align:left;margin:20px;}
	 #dbs thead{background:#ddd;}
	 #dbs th{font-size:12px;font-weight:bold;color:#336;border-bottom:2px solid #336;padding:7px 8px;}
	 #dbs td{border-bottom:1px solid #ccc;color:#336;padding:3px 8px;white-space: pre;}
	 td.subpart{font-weight:bold;background:#ddd}
	 td.name{background:#f2f2f2}
	 #dbs tbody tr:hover td{color:#000;background:#fffcea;}
</style>
</head>

<body>
<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink'   width='1526' height='2164' viewbox='0 0 1526 2164' >
<style type='text/css'>
  text                { text-rendering: optimizeLegibility; fill:#000000; font-family: Candara, Dialog, Arial; font-size:12px; }
  text.fk             { fill:#6e1850; }
  text.pk             { fill:#0c31a1; }
  text.colType        { fill:#a9bdc6; }
  text.tableTitle     { fill:#0f0f0f; font-weight:bold; }
  path                { stroke:#4d423e; stroke-width:1.5; fill:none; }
  rect.grp            { opacity:0.5; stroke:#c2ab83; stroke-width:1; }
  rect.table          { fill:#ffffff; stroke:#495272; stroke-width:0.5; filter:url(#shadow); }
  line.table          { stroke:#495272; stroke-width:0.5; }
  rect.callout        { fill:url(#calloutGradient); stroke:#aea913; stroke-width:0.5; }
  path.callout        { fill:#f4f1a4; stroke:#aea913; stroke-width:0.5; }
</style>
<defs>
  <pattern id='layoutGradient' patternUnits='userSpaceOnUse' x='0' y='0' width='10' height='10' viewBox='0 0 10 10'>
    <rect x='0' y='0' width='10' height='10' style='fill:#f9f8f2;' />
    <line x1='5' y1='10' x2='5' y2='0' style='stroke:#949494;stroke-width:0.5;stroke-dasharray:1,9;'  />
  </pattern>
  <radialGradient id='layoutGradientOld' cx='20%' cy='20%' r='25%' fx='10%' fy='0%'>
	   <stop offset='0%' stop-color='#ffffff' />
    <stop offset='100%' stop-color='#efefef' />
  </radialGradient>
  <linearGradient id='tableHeaderGradient' x1='0%' y1='0%' x2='0%' y2='100%' >
          <stop offset='0%' stop-color='#eff7fc' stop-opacity='1'/> 
          <stop offset='50%' stop-color='#d9e5f6' stop-opacity='1'/> 
          <stop offset='51%' stop-color='#bdd4f1' stop-opacity='1'/> 
          <stop offset='100%' stop-color='#d6e2f9' stop-opacity='1' /> 
   </linearGradient>
  <radialGradient id='calloutGradient' cx='20%' cy='20%' r='100%' fx='10%' fy='10%'>
	   <stop offset='0%' stop-color='#ffffff' />
    <stop offset='100%' stop-color='#f4f1a4' />
  </radialGradient>
  <filter id='shadow' width='150%' height='150%'> 
    <feGaussianBlur in='SourceAlpha' stdDeviation='3' result='image1' /> 
    <feOffset in='image1' result='image2' dx='2' dy='2' />
    <feComposite in='SourceGraphic' in2='image2' operator='over' /> 
  </filter>
  <filter id='emboss'> 
    <feGaussianBlur in='SourceAlpha' stdDeviation='2' result='blur'/> 
    <feSpecularLighting in='blur' surfaceScale='-3' style='lighting-color:white' 
      specularConstant='1' specularExponent='16' result='spec' kernelUnitLength='1' >
      <feDistantLight azimuth='45' elevation='45' />
    </feSpecularLighting> 
    <feComposite in='spec' in2='SourceGraphic' operator='in' result='specOut'/> 
    <feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>  
  </filter>
  <filter id='embossAndShadow' filterUnits='userSpaceOnUse' x='0' y='0' width='400' height='120'> 
     <feGaussianBlur in='SourceAlpha' stdDeviation='4' result='blur'/> 
     <feOffset in='blur' dx='4' dy='4' result='offsetBlur'/> 
     <feSpecularLighting in='blur' surfaceScale='5' specularConstant='.75' specularExponent='20' lighting-color='#bbbbbb' result='specOut'>
        <fePointLight x='-5000' y='-10000' z='20000'/>  
     </feSpecularLighting> 
     <feComposite in='specOut' in2='SourceAlpha' operator='in' result='specOut'/> 
     <feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>  
     <feMerge> 
         <feMergeNode in='offsetBlur'/> 
         <feMergeNode in='litPaint'/> 
     </feMerge> 
  </filter> 
  <radialGradient id='legendGradient' fx='5%' fy='5%' r='75%' spreadMethod='pad'>
          <stop offset='0%' stop-color='#6985ff' stop-opacity='1'/> 
          <stop offset='100%' stop-color='#1e2a5f' stop-opacity='1' /> 
   </radialGradient>
  <pattern id='hintPointerSV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,0 Q 7,7,0,13 Q 13,7,13,0' class='callout' />
  </pattern>
  <pattern id='hintPointerSE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,0 Q 3,7,13,13 Q 7,7,13,0' class='callout' />
  </pattern>
  <pattern id='hintPointerNV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,13 Q 7,7,0,0 Q 13,7,13,13' class='callout' />
  </pattern>
  <pattern id='hintPointerNE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,13 Q 3,7,13,0 Q 7,7,13,13' class='callout' />
  </pattern>
  <symbol id='pk' overflow='visible' >
    <g transform='scale(0.85)'>
     <path style='fill:#e9ad16;stroke:#9c4f15;stroke-width:0.7;stroke-linecap:round;stroke-linejoin:round;filter:url(#emboss);'
        d='M 9.3678877,3.5695485 C 9.1030218,3.2729386 9.0796382,2.7628519 9.3396185,2.4517097 9.5449651,2.1956495 9.9040386,2.0980533 10.199638,2.2169415 10.533525,2.3415459 10.775153,2.706942 10.750675,3.0842709 10.737029,3.3980003 10.541153,3.699122 10.258248,3.8066067 9.966649,3.9250429 9.6169668,3.8418805 9.4008073,3.6062324 9.3894892,3.5943518 9.3785264,3.582104 9.3678886,3.5695487 z M 11.226617,6.9916004 C 11.888137,6.3548946 12.293488,5.4172188 12.311087,4.442353 12.378144,2.7379364 11.248678,1.0541269 9.7322318,0.44767357 8.3887112,-0.1280313 6.7865012,0.26822889 5.8918395,1.4007929 5.080823,2.3839145 4.9336815,3.8452096 5.3635544,5.101615 L 4.3670905,5.315913 C 4.0664984,5.3682645 4.0967703,5.6316724 4.2574957,5.8208829 L 4.9124,6.5655244 4.1543436,7.2512357 3.2136002,7.2163506 3.1674775,8.5586827 2.0406832,8.5086512 1.5965306,8.9299953 1.5471661,10.179833 0.75616674,10.195223 0.2112857,10.758575 0.15354288,11.735988 0.07199052,12.765553 c 0.36440953,0.238225 0.79006967,0.195492 1.44938278,-0.02675 L 6.3033562,8.1282037 6.8217102,8.6765688 C 6.9985465,8.8799427 7.3003699,8.7497574 7.358381,8.5016252 L 7.4938877,7.5084164 c 0.8537488,0.3985387 1.8303125,0.4711541 2.6851793,0.1427713 0.393927,-0.1407258 0.746858,-0.3701772 1.04755,-0.6595873 z'/>
     <path d='M 6.8014948,6.3102123 0.15369063,13.024481 0.21560535,12.141962 6.0062342,6.2683782 z'
        style='fill:#ffe5a5;fill-opacity:1;stroke:#854e31;stroke-width:0.09912433;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;stroke-opacity:1;stroke-dasharray:none;stroke-dashoffset:3.00300009'/>
    </g>
  </symbol>
  <symbol id='unq' overflow='visible' >
    <g transform='scale(0.85)'>
      <rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
         width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
      <path style='fill:#ffffe2;stroke:#313131;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
         d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
         transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
      <text x='5.2' y='6.6' style='font-size:8px;fill:#7c0909;'>1</text>
    </g>
  </symbol>
  <symbol id='idx' overflow='visible' >
    <g transform='scale(0.85)'>
      <rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
         width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
      <path style='fill:#ffffe2;stroke:#313131;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
         d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
         transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
    </g>
  </symbol>
  <symbol id='fk' overflow='visible' >
    <path style='fill:#946d00;stroke:#5c2352;stroke-width:0.46;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
    d='M 12.48,0.33 7.07,0.89 9.067,2.974 0.329,11.731 1.073,12.597 9.811,3.841 11.77,5.78 z' />
  </symbol>
  <symbol id='ref' overflow='visible' >
  <path style='fill:#1877c8;stroke:#29365f;stroke-width:0.4;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
          d='M 0.10,12.70 5.31,12.15 3.40,10.06 11.82,1.32 11.11,0.45 2.68,9.19 0.80,7.24 z'/>
  </symbol>
  <marker id='arrow' viewBox='0 0 7 7' refX='0' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
    <path d='M 0,0 L 7, 3 L 0,7 z' style='fill:#776c57; stroke-width:0px;' />
  </marker>
  <marker id='foot' viewBox='0 0 7 7' refX='7' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
    <path d='M 0,3 L 14, 3 z' style='stroke:#776c57;' />
  </marker>
</defs>

<!-- ============= Desktop ============= -->
<rect x='1' y='1' width='1524' height='2162' rx='7' ry='7' style='fill:url(#layoutGradient); stroke:#104576; stroke-width:0.5;' />

<!-- ============= Legend ============= -->
<g transform='translate(10,10)'>
  <rect x='10' y='10' width='300' height='100' rx='6' ry='6' style='fill:url(#legendGradient);filter:url(#embossAndShadow);'/> 
  <text x='25' y='30' style='fill:white'>'College_DB_Schema' Database Schema</text> 
  <text x='25' y='44' style='fill:white'>'College_DB_Schema' Layout</text> 
  <a xlink:href='http://www.dbschema.com' title='Visit http://www.dbschema.com'> 
    <text x='25' y='58' style='fill:white'>Generated using DbSchema</text> 
  </a>

  <text x='25' y='80' style='fill:white'>Move the mouse over columns and symbols</text> 
  <a xlink:href='http://www.dbschema.com' title='Primary Key Icon'><use id='pk' x='240' y='72' xlink:href='#pk'/></a>  <a xlink:href='http://www.dbschema.com' title='Index Icon'><use id='idx' x='254' y='72' xlink:href='#idx'/></a>  <a xlink:href='http://www.dbschema.com' title='Foreign Key Icon'><use id='fk' x='268' y='72' xlink:href='#fk'/></a>  <text x='25' y='94' style='fill:white'>to read the tool-tip comments.</text> 
</g>

<g transform='translate(0,120)'>
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_book_borrow_book_id student_book_borrow to library_book_details ( book_id )' d='M 238 1568 L 189,1568 Q 182,1568 182,1561 L 182,1561 Q 182,1554 175,1554 L 168,1554'  />

<text x='198' y='1564' transform='rotate(0 198,1564)' title='fk_student_book_borrow_book_id student_book_borrow to library_book_details ( book_id )'>book_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_book_borrow_borrower_id student_book_borrow to student_details ( borrower_id -> student_id )' d='M 238 1582 L 231,1582 Q 224,1582 224,1575 L 224,1260'  />

<text x='177' y='1578' transform='rotate(0 177,1578)' title='fk_student_book_borrow_borrower_id student_book_borrow to student_details ( borrower_id -> student_id )'>borrower_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_residential_room_residential_id residential_room to college_residential ( residential_id )' d='M 252 1344 L 182,1344'  />

<text x='185' y='1340' transform='rotate(0 185,1340)' title='fk_residential_room_residential_id residential_room to college_residential ( residential_id )'>residential_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_login_info_student_details login_info to student_details ( login_id -> email_id )' d='M 238 1778 L 217,1778 Q 210,1778 210,1771 L 210,1260'  />

<text x='199' y='1774' transform='rotate(0 199,1774)' title='fk_login_info_student_details login_info to student_details ( login_id -> email_id )'>login_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_group_member_group group_member to group ( group_id )' d='M 1036 980 L 1036,1603 Q 1036,1610 1043,1610 L 1050,1610'  />

<text x='1045' y='982' transform='rotate(90 1045,982)' title='fk_group_member_group group_member to group ( group_id )'>group_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_group_member_member_id_type_1 group_member to student_batch ( member_id -> student_batch_id )' d='M 980 854 L 504,854'  />

<text x='924' y='850' transform='rotate(0 924,850)' title='fk_group_member_member_id_type_1 group_member to student_batch ( member_id -> student_batch_id )'>member_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_group_member_member_id_type_2 group_member to college_staff ( member_id -> staff_id )' d='M 980 882 L 525,882 Q 518,882 518,889 L 518,1267 Q 518,1274 511,1274 L 203,1274 Q 196,1274 196,1281 L 196,1589 Q 196,1596 189,1596 L 168,1596'  />

<text x='924' y='878' transform='rotate(0 924,878)' title='fk_group_member_member_id_type_2 group_member to college_staff ( member_id -> staff_id )'>member_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_group_member_added_by_id_type_1 group_member to student_batch ( added_by_id -> student_batch_id )' d='M 980 868 L 504,868'  />

<text x='915' y='864' transform='rotate(0 915,864)' title='fk_group_member_added_by_id_type_1 group_member to student_batch ( added_by_id -> student_batch_id )'>added_by_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_group_member_added_by_id_type_2 group_member to college_staff ( added_by_id -> staff_id )' d='M 980 952 L 791,952 Q 784,952 784,959 L 784,1253 Q 784,1260 777,1260 L 413,1260 Q 406,1260 406,1267 L 406,1701 Q 406,1708 399,1708 L 168,1708'  />

<text x='915' y='948' transform='rotate(0 915,948)' title='fk_group_member_added_by_id_type_2 group_member to college_staff ( added_by_id -> staff_id )'>added_by_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_year_semester_id student_course to degree_current_year_semester ( year_semester_id )' d='M 434 588 L 693,588 Q 700,588 700,581 L 700,322'  />

<text x='443' y='584' transform='rotate(0 443,584)' title='fk_student_course_year_semester_id student_course to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_degree_course_id student_course to degree_course ( degree_course_id )' d='M 308 560 L 308,462'  />

<text x='311' y='556' transform='rotate(270 311,556)' title='fk_student_course_degree_course_id student_course to degree_course ( degree_course_id )'>degree_course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_student_id student_course to student_details ( student_id )' d='M 280 672 L 259,672 Q 252,672 252,679 L 252,770'  />

<text x='228' y='668' transform='rotate(0 228,668)' title='fk_student_course_student_id student_course to student_details ( student_id )'>student_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_batch_batch_id student_batch to batch_details ( batch_id )' d='M 448 770 L 448,315 Q 448,308 441,308 L 420,308'  />

<text x='451' y='766' transform='rotate(270 451,766)' title='fk_student_batch_batch_id student_batch to batch_details ( batch_id )'>batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_batch_student_id student_batch to student_details ( student_id )' d='M 322 798 L 266,798'  />

<text x='270' y='794' transform='rotate(0 270,794)' title='fk_student_batch_student_id student_batch to student_details ( student_id )'>student_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_batch_department_degree_id student_batch to degree_department ( degree_department_id )' d='M 462 770 L 462,119 Q 462,112 455,112 L 203,112 Q 196,112 196,119 L 196,126'  />

<text x='465' y='766' transform='rotate(270 465,766)' title='fk_student_batch_department_degree_id student_batch to degree_department ( degree_department_id )'>degree_department_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_batch_room_id student_batch to residential_room ( room_id )' d='M 322 896 L 315,896 Q 308,896 308,903 L 308,1330'  />

<text x='281' y='892' transform='rotate(0 281,892)' title='fk_student_batch_room_id student_batch to residential_room ( room_id )'>room_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_finance_one_time_student_batch_id student_finance_one_time to student_batch ( student_batch_id )' d='M 364 1050 L 364,924'  />

<text x='367' y='1046' transform='rotate(270 367,1046)' title='fk_student_finance_one_time_student_batch_id student_finance_one_time to student_batch ( student_batch_id )'>student_batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_group_update_group_id group_update to group ( group_id )' d='M 714 784 L 1211,784 Q 1218,784 1218,791 L 1218,1617 Q 1218,1624 1211,1624 L 1204,1624'  />

<text x='723' y='780' transform='rotate(0 723,780)' title='fk_group_update_group_id group_update to group ( group_id )'>group_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_group_update_member_id group_update to group_member ( member_id -> group_id )' d='M 714 770 L 777,770 Q 784,770 784,777 L 784,819 Q 784,826 791,826 L 1001,826 Q 1008,826 1008,833 L 1008,840'  />

<text x='723' y='766' transform='rotate(0 723,766)' title='fk_group_update_member_id group_update to group_member ( member_id -> group_id )'>member_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_group_update_document_id group_update to document_upload ( document_id )' d='M 560 770 L 539,770 Q 532,770 532,777 L 532,1239 Q 532,1246 525,1246 L 469,1246 Q 462,1246 462,1253 L 462,1855 Q 462,1862 469,1862 L 490,1862'  />

<text x='495' y='766' transform='rotate(0 495,766)' title='fk_group_update_document_id group_update to document_upload ( document_id )'>document_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_management_degree_id degree_management to degree_details ( degree_id )' d='M 798 644 L 483,644 Q 476,644 476,637 L 476,553 Q 476,546 469,546 L 182,546'  />

<text x='750' y='640' transform='rotate(0 750,640)' title='fk_degree_management_degree_id degree_management to degree_details ( degree_id )'>degree_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_management_batch_id degree_management to batch_details ( batch_id )' d='M 896 630 L 896,189 Q 896,182 889,182 L 420,182'  />

<text x='899' y='626' transform='rotate(270 899,626)' title='fk_degree_management_batch_id degree_management to batch_details ( batch_id )'>batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_financial_semester_wise_student_batch_id student_financial_semester_wise to student_batch ( student_batch_id )' d='M 574 910 L 504,910'  />

<text x='487' y='906' transform='rotate(0 487,906)' title='fk_student_financial_semester_wise_student_batch_id student_financial_semester_wise to student_batch ( student_batch_id )'>student_batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_financial_semester_wise_year_semester_id student_financial_semester_wise to degree_current_year_semester ( year_semester_id )' d='M 728 896 L 728,553 Q 728,546 721,546 L 721,546 Q 714,546 714,539 L 714,322'  />

<text x='731' y='892' transform='rotate(270 731,892)' title='fk_student_financial_semester_wise_year_semester_id student_financial_semester_wise to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_placed_company__id student_placed to placements ( company_id )' d='M 630 1316 L 1141,1316 Q 1148,1316 1148,1309 L 1148,728'  />

<text x='639' y='1312' transform='rotate(0 639,1312)' title='fk_student_placed_company__id student_placed to placements ( company_id )'>company_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_placed_student_batch_id student_placed to student_batch ( student_batch_id )' d='M 546 1288 L 546,903 Q 546,896 539,896 L 504,896'  />

<text x='549' y='1284' transform='rotate(270 549,1284)' title='fk_student_placed_student_batch_id student_placed to student_batch ( student_batch_id )'>student_batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_profile_picture_user_id student_profile_picture to student_details ( user_id -> student_id )' d='M 602 1218 L 266,1218'  />

<text x='568' y='1214' transform='rotate(0 568,1214)' title='fk_student_profile_picture_user_id student_profile_picture to student_details ( user_id -> student_id )'>user_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_project_student_course_id student_course_project to student_course ( student_course_id )' d='M 210 1946 L 469,1946 Q 476,1946 476,1939 L 476,1645 Q 476,1638 469,1638 L 427,1638 Q 420,1638 420,1631 L 420,1239 Q 420,1232 413,1232 L 301,1232 Q 294,1232 294,1225 L 294,721 Q 294,714 301,714 L 301,714 Q 308,714 308,707 L 308,700'  />

<text x='219' y='1942' transform='rotate(0 219,1942)' title='fk_student_course_project_student_course_id student_course_project to student_course ( student_course_id )'>student_course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_project student_course_project to degree_current_year_semester ( year_semester_id )' d='M 42 1834 L 21,1834 Q 14,1834 14,1827 L 14,105 Q 14,98 21,98 L 693,98 Q 700,98 700,105 L 700,196'  />

<text x='-45' y='1830' transform='rotate(0 -45,1830)' title='fk_student_course_project student_course_project to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_course_project_professor_id student_course_project to college_staff ( professor_id -> staff_id )' d='M 70 1820 L 70,1792'  />

<text x='73' y='1816' transform='rotate(270 73,1816)' title='fk_student_course_project_professor_id student_course_project to college_staff ( professor_id -> staff_id )'>professor_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_result_student_id student_result to student_batch ( student_id -> student_batch_id )' d='M 476 1456 L 441,1456 Q 434,1456 434,1449 L 434,1253 Q 434,1246 427,1246 L 329,1246 Q 322,1246 322,1239 L 322,945 Q 322,938 329,938 L 343,938 Q 350,938 350,931 L 350,924'  />

<text x='424' y='1452' transform='rotate(0 424,1452)' title='fk_student_result_student_id student_result to student_batch ( student_id -> student_batch_id )'>student_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_result_year_semester_id student_result to degree_current_year_semester ( year_semester_id )' d='M 644 1470 L 763,1470 Q 770,1470 770,1463 L 770,1127 Q 770,1120 777,1120 L 791,1120 Q 798,1120 798,1113 L 798,805 Q 798,798 791,798 L 749,798 Q 742,798 742,791 L 742,567 Q 742,560 735,560 L 693,560 Q 686,560 686,553 L 686,343 Q 686,336 693,336 L 721,336 Q 728,336 728,329 L 728,322'  />

<text x='653' y='1466' transform='rotate(0 653,1466)' title='fk_student_result_year_semester_id student_result to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_student_result_course_professor_id student_result to course_professor ( course_professor_id )' d='M 644 1484 L 784,1484'  />

<text x='653' y='1480' transform='rotate(0 653,1480)' title='fk_student_result_course_professor_id student_result to course_professor ( course_professor_id )'>course_professor_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_course_professor_course_id course_professor to course_details ( course_id )' d='M 784 1414 L 455,1414 Q 448,1414 448,1407 L 448,1295 Q 448,1288 441,1288 L 287,1288 Q 280,1288 280,1281 L 280,763 Q 280,756 273,756 L 168,756'  />

<text x='738' y='1410' transform='rotate(0 738,1410)' title='fk_course_professor_course_id course_professor to course_details ( course_id )'>course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_course_professor_professor_id_1 course_professor to college_staff ( professor_id_1 -> staff_id )' d='M 784 1428 L 455,1428 Q 448,1428 448,1435 L 448,1715 Q 448,1722 441,1722 L 168,1722'  />

<text x='712' y='1424' transform='rotate(0 712,1424)' title='fk_course_professor_professor_id_1 course_professor to college_staff ( professor_id_1 -> staff_id )'>professor_id_1</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_course_professor_professor_id_2 course_professor to college_staff ( professor_id_2 -> staff_id )' d='M 784 1568 L 665,1568 Q 658,1568 658,1575 L 658,1729 Q 658,1736 651,1736 L 168,1736'  />

<text x='710' y='1564' transform='rotate(0 710,1564)' title='fk_course_professor_professor_id_2 course_professor to college_staff ( professor_id_2 -> staff_id )'>professor_id_2</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_course_professor_professor_id_3 course_professor to college_staff ( professor_id_3 -> staff_id )' d='M 784 1554 L 679,1554 Q 672,1554 672,1561 L 672,1743 Q 672,1750 665,1750 L 168,1750'  />

<text x='710' y='1550' transform='rotate(0 710,1550)' title='fk_course_professor_professor_id_3 course_professor to college_staff ( professor_id_3 -> staff_id )'>professor_id_3</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_student_resume_student_batch_id student_resume to student_batch ( student_batch_id )' d='M 910 1666 L 973,1666 Q 980,1666 980,1659 L 980,1141 Q 980,1134 973,1134 L 567,1134 Q 560,1134 560,1127 L 560,945 Q 560,938 553,938 L 497,938 Q 490,938 490,931 L 490,924'  />

<text x='919' y='1662' transform='rotate(0 919,1662)' title='fk_student_resume_student_batch_id student_resume to student_batch ( student_batch_id )'>student_batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_document_upload_uploader_id_type_2 document_upload to college_staff ( uploader_id -> staff_id )' d='M 490 1932 L 469,1932 Q 462,1932 462,1939 L 462,1953 Q 462,1960 455,1960 L 231,1960 Q 224,1960 224,1953 L 224,1771 Q 224,1764 217,1764 L 168,1764'  />

<text x='431' y='1928' transform='rotate(0 431,1928)' title='fk_document_upload_uploader_id_type_2 document_upload to college_staff ( uploader_id -> staff_id )'>uploader_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_placements_student_batch placements to student_batch ( student_batch_id )' d='M 994 616 L 497,616 Q 490,616 490,623 L 490,770'  />

<text x='907' y='612' transform='rotate(0 907,612)' title='fk_placements_student_batch placements to student_batch ( student_batch_id )'>student_batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_course_management_course_id course_management to course_details ( course_id )' d='M 504 392 L 441,392 Q 434,392 434,399 L 434,525 Q 434,532 427,532 L 203,532 Q 196,532 196,539 L 196,637 Q 196,644 189,644 L 168,644'  />

<text x='458' y='388' transform='rotate(0 458,388)' title='fk_course_management_course_id course_management to course_details ( course_id )'>course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_course_management_batch_id course_management to batch_details ( batch_id )' d='M 504 266 L 420,266'  />

<text x='462' y='262' transform='rotate(0 462,262)' title='fk_course_management_batch_id course_management to batch_details ( batch_id )'>batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_professor_work_course_id professor_work to course_details ( course_id )' d='M 1162 1400 L 1162,819 Q 1162,812 1155,812 L 525,812 Q 518,812 518,805 L 518,749 Q 518,742 511,742 L 168,742'  />

<text x='1165' y='1396' transform='rotate(270 1165,1396)' title='fk_professor_work_course_id professor_work to course_details ( course_id )'>course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_professor_work professor_work to degree_current_year_semester ( year_semester_id )' d='M 1190 1400 L 1190,343 Q 1190,336 1183,336 L 861,336 Q 854,336 854,329 L 854,322'  />

<text x='1193' y='1396' transform='rotate(270 1193,1396)' title='fk_professor_work professor_work to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_group_owner_id_type_1 group to student_batch ( owner_id -> student_batch_id )' d='M 1050 1624 L 1001,1624 Q 994,1624 994,1617 L 994,1001 Q 994,994 987,994 L 819,994 Q 812,994 812,987 L 812,847 Q 812,840 805,840 L 504,840'  />

<text x='1004' y='1620' transform='rotate(0 1004,1620)' title='fk_group_owner_id_type_1 group to student_batch ( owner_id -> student_batch_id )'>owner_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_professor_details professor_department to department_details ( department_id )' d='M 952 1162 L 952,805 Q 952,798 959,798 L 973,798 Q 980,798 980,791 L 980,609 Q 980,602 973,602 L 497,602 Q 490,602 490,595 L 490,483 Q 490,476 483,476 L 203,476 Q 196,476 196,469 L 196,455 Q 196,448 189,448 L 182,448'  />

<text x='955' y='1158' transform='rotate(270 955,1158)' title='fk_professor_details professor_department to department_details ( department_id )'>department_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_current_year_semester_degree_department_id degree_current_year_semester to degree_department ( degree_department_id )' d='M 672 210 L 441,210 Q 434,210 434,203 L 434,91 Q 434,84 427,84 L 189,84 Q 182,84 182,91 L 182,126'  />

<text x='557' y='206' transform='rotate(0 557,206)' title='fk_degree_current_year_semester_degree_department_id degree_current_year_semester to degree_department ( degree_department_id )'>degree_department_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_college_staff_financial college_staff_financial to college_staff ( staff_id )' d='M 504 490 L 217,490 Q 210,490 210,483 L 210,343 Q 210,336 203,336 L 7,336 Q 0,336 0,343 L 0,1575 Q 0,1582 7,1582 L 28,1582'  />

<text x='468' y='486' transform='rotate(0 468,486)' title='fk_college_staff_financial college_staff_financial to college_staff ( staff_id )'>staff_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_department_batch_id degree_department to batch_details ( batch_id )' d='M 210 168 L 280,168'  />

<text x='219' y='164' transform='rotate(0 219,164)' title='fk_degree_department_batch_id degree_department to batch_details ( batch_id )'>batch_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_department_department_id degree_department to department_details ( department_id )' d='M 56 266 L 56,350'  />

<text x='65' y='268' transform='rotate(90 65,268)' title='fk_degree_department_department_id degree_department to department_details ( department_id )'>department_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_department_degree_id degree_department to degree_details ( degree_id )' d='M 210 252 L 217,252 Q 224,252 224,259 L 224,497 Q 224,504 217,504 L 182,504'  />

<text x='219' y='248' transform='rotate(0 219,248)' title='fk_degree_department_degree_id degree_department to degree_details ( degree_id )'>degree_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_course_year_semester_id degree_course to degree_current_year_semester ( year_semester_id )' d='M 420 364 L 483,364 Q 490,364 490,357 L 490,245 Q 490,238 497,238 L 672,238'  />

<text x='429' y='360' transform='rotate(0 429,360)' title='fk_degree_course_year_semester_id degree_course to degree_current_year_semester ( year_semester_id )'>year_semester_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_degree_course_id degree_course to course_details ( course_id )' d='M 266 434 L 245,434 Q 238,434 238,441 L 238,651 Q 238,658 231,658 L 168,658'  />

<text x='220' y='430' transform='rotate(0 220,430)' title='fk_degree_course_id degree_course to course_details ( course_id )'>course_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_follow_follower_id_type_1 follow to student_batch ( follower_id -> student_batch_id )' d='M 756 532 L 756,819 Q 756,826 749,826 L 504,826'  />

<text x='765' y='534' transform='rotate(90 765,534)' title='fk_follow_follower_id_type_1 follow to student_batch ( follower_id -> student_batch_id )'>follower_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_follow_following_id_type_1 follow to batch_details ( following_id -> batch_id )' d='M 868 420 L 868,357 Q 868,350 875,350 L 875,350 Q 882,350 882,343 L 882,147 Q 882,140 875,140 L 413,140 Q 406,140 406,147 L 406,154'  />

<text x='871' y='416' transform='rotate(270 871,416)' title='fk_follow_following_id_type_1 follow to batch_details ( following_id -> batch_id )'>following_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_follow_following_id_type_4 follow to course_details ( following_id -> course_id )' d='M 728 504 L 679,504 Q 672,504 672,511 L 672,623 Q 672,630 665,630 L 511,630 Q 504,630 504,637 L 504,721 Q 504,728 497,728 L 168,728'  />

<text x='666' y='500' transform='rotate(0 666,500)' title='fk_follow_following_id_type_4 follow to course_details ( following_id -> course_id )'>following_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_course_details course_details to department_details ( department_id )' d='M 168 686 L 259,686 Q 266,686 266,679 L 266,511 Q 266,504 259,504 L 259,504 Q 252,504 252,497 L 252,427 Q 252,420 245,420 L 182,420'  />

<text x='177' y='682' transform='rotate(0 177,682)' title='fk_course_details course_details to department_details ( department_id )'>department_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_posts_posted_by_id_type_2 posts to college_staff ( posted_by_id -> staff_id )' d='M 714 1960 L 665,1960 Q 658,1960 658,1967 L 658,2009 Q 658,2016 651,2016 L 35,2016 Q 28,2016 28,2009 L 28,1813 Q 28,1806 35,1806 L 49,1806 Q 56,1806 56,1799 L 56,1792'  />

<text x='646' y='1956' transform='rotate(0 646,1956)' title='fk_posts_posted_by_id_type_2 posts to college_staff ( posted_by_id -> staff_id )'>posted_by_id</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_message_attachment_id message to document_upload ( attachment_id -> document_id )' d='M 1064 1862 L 665,1862 Q 658,1862 658,1869 L 658,1869 Q 658,1876 651,1876 L 644,1876'  />

<text x='992' y='1858' transform='rotate(0 992,1858)' title='fk_message_attachment_id message to document_upload ( attachment_id -> document_id )'>attachment_id</text><!-- ============= Table 'student_details' ============= -->
<rect class='table' x='42' y='777' width='224' height='476' rx='7' ry='7' />
<path d='M 42.50 798.00 L 42.50 784.50 Q 42.50 777.50 49.50 777.50 L 258.50 777.50 Q 265.50 777.50 265.50 784.50 L 265.50 798.00 L42.50 798.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_details' title='college_db_schema.student_details' ><text x='114' y='791' class='tableTitle'>student_details</text></a>
  <a xlink:href='#student_id' title='Primary Key  ( student_id ) '><use id='pk' x='44' y='810' xlink:href='#pk'/></a>
<a xlink:href='#student_id' title='INT not null '><text x='56' y='819' class='pk'>student_id</text></a>
<a xlink:href='#student_id' title='Referred by student_course ( student_id ) Referred by student_batch ( student_id ) Referred by student_book_borrow ( borrower_id -> student_id ) Referred by student_profile_picture ( user_id -> student_id ) '><use id='ref' x='252' y='808' xlink:href='#ref'/></a>
  <a xlink:href='#student_name' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='833' >student_name</text></a>
  <a xlink:href='#roll_number' title='VARCHAR&#040; 20 &#041; not null '><text x='56' y='847' >roll_number</text></a>
  <a xlink:href='#registration_number' title='VARCHAR&#040; 20 &#041; not null '><text x='56' y='861' >registration_number</text></a>
  <a xlink:href='#mobile_number' title='VARCHAR&#040; 20 &#041; '><text x='56' y='875' >mobile_number</text></a>
  <a xlink:href='#phone_number' title='VARCHAR&#040; 20 &#041; '><text x='56' y='889' >phone_number</text></a>
  <a xlink:href='#address_line_1' title='VARCHAR&#040; 100 &#041; '><text x='56' y='903' >address_line_1</text></a>
  <a xlink:href='#address_line_2' title='VARCHAR&#040; 100 &#041; '><text x='56' y='917' >address_line_2</text></a>
  <a xlink:href='#city' title='VARCHAR&#040; 50 &#041; not null '><text x='56' y='931' >city</text></a>
  <a xlink:href='#state' title='VARCHAR&#040; 50 &#041; not null '><text x='56' y='945' >state</text></a>
  <a xlink:href='#country' title='VARCHAR&#040; 50 &#041; not null '><text x='56' y='959' >country</text></a>
  <a xlink:href='#email_id' title='Unique Index  ( email_id ) '><use id='unq' x='44' y='964' xlink:href='#unq'/></a>
<a xlink:href='#email_id' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='973' >email_id</text></a>
<a xlink:href='#email_id' title='Referred by login_info ( login_id -> email_id ) '><use id='ref' x='252' y='962' xlink:href='#ref'/></a>
  <a xlink:href='#date_of_birth' title='DATE not null '><text x='56' y='987' >date_of_birth</text></a>
  <a xlink:href='#highest_degree' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1001' >highest_degree</text></a>
  <a xlink:href='#highest_degree_marks' title='INT '><text x='56' y='1015' >highest_degree_marks</text></a>
  <a xlink:href='#highest_degree_college_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1029' >highest_degree_college_name</text></a>
  <a xlink:href='#highest_degree_passout_year' title='INT '><text x='56' y='1043' >highest_degree_passout_year</text></a>
  <a xlink:href='#previous_degree_1' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1057' >previous_degree_1</text></a>
  <a xlink:href='#previous_degree_1_marks' title='INT '><text x='56' y='1071' >previous_degree_1_marks</text></a>
  <a xlink:href='#previous_degree_1_college_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1085' >previous_degree_1_college_name</text></a>
  <a xlink:href='#previous_degree_1_passout_year' title='INT '><text x='56' y='1099' >previous_degree_1_passout_year</text></a>
  <a xlink:href='#previous_degree_2' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1113' >previous_degree_2</text></a>
  <a xlink:href='#previous_degree_2_marks' title='INT '><text x='56' y='1127' >previous_degree_2_marks</text></a>
  <a xlink:href='#previous_degree_2_college_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1141' >previous_degree_2_college_name</text></a>
  <a xlink:href='#previous_degree_2_passout_year' title='INT '><text x='56' y='1155' >previous_degree_2_passout_year</text></a>
  <a xlink:href='#years_of_experience' title='FLOAT '><text x='56' y='1169' >years_of_experience</text></a>
  <a xlink:href='#gender' title='VARCHAR&#040; 10 &#041; '><text x='56' y='1183' >gender</text></a>
  <a xlink:href='#father_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1197' >father_name</text></a>
  <a xlink:href='#pan_card_number' title='VARCHAR&#040; 20 &#041; '><text x='56' y='1211' >pan_card_number</text></a>
  <a xlink:href='#passport_number' title='VARCHAR&#040; 20 &#041; '><text x='56' y='1225' >passport_number</text></a>
  <a xlink:href='#passport_expiry_date' title='DATE '><text x='56' y='1239' >passport_expiry_date</text></a>

<!-- ============= Table 'college_residential' ============= -->
<rect class='table' x='42' y='1267' width='140' height='126' rx='7' ry='7' />
<path d='M 42.50 1288.00 L 42.50 1274.50 Q 42.50 1267.50 49.50 1267.50 L 174.50 1267.50 Q 181.50 1267.50 181.50 1274.50 L 181.50 1288.00 L42.50 1288.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#college_residential' title='college_db_schema.college_residential' ><text x='64' y='1281' class='tableTitle'>college_residential</text></a>
  <a xlink:href='#residential_id' title='Primary Key  ( residential_id ) '><use id='pk' x='44' y='1300' xlink:href='#pk'/></a>
<a xlink:href='#residential_id' title='INT not null '><text x='56' y='1309' class='pk'>residential_id</text></a>
<a xlink:href='#residential_id' title='Referred by residential_room ( residential_id ) '><use id='ref' x='168' y='1298' xlink:href='#ref'/></a>
  <a xlink:href='#residential_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1323' >residential_name</text></a>
  <a xlink:href='#residential_type' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1337' >residential_type</text></a>
  <a xlink:href='#warden_id' title='INT '><text x='56' y='1351' >warden_id</text></a>
  <a xlink:href='#warden_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1365' >warden_name</text></a>
  <a xlink:href='#capacity' title='INT '><text x='56' y='1379' >capacity</text></a>

<!-- ============= Table 'student_book_borrow' ============= -->
<rect class='table' x='252' y='1561' width='140' height='126' rx='7' ry='7' />
<path d='M 252.50 1582.00 L 252.50 1568.50 Q 252.50 1561.50 259.50 1561.50 L 384.50 1561.50 Q 391.50 1561.50 391.50 1568.50 L 391.50 1582.00 L252.50 1582.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_book_borrow' title='college_db_schema.student_book_borrow' ><text x='264' y='1575' class='tableTitle'>student_book_borrow</text></a>
  <a xlink:href='#borrower_id' title='Index  ( borrower_id ) '><use id='idx' x='254' y='1594' xlink:href='#idx'/></a>
<a xlink:href='#borrower_id' title='INT '><text x='266' y='1603' class='fk'>borrower_id</text></a>
<a xlink:href='#borrower_id' title='References student_details ( borrower_id -> student_id ) '><use id='fk' x='378' y='1592' xlink:href='#fk'/></a>
  <a xlink:href='#book_id' title='Index  ( book_id ) '><use id='idx' x='254' y='1608' xlink:href='#idx'/></a>
<a xlink:href='#book_id' title='INT '><text x='266' y='1617' class='fk'>book_id</text></a>
<a xlink:href='#book_id' title='References library_book_details ( book_id ) '><use id='fk' x='378' y='1606' xlink:href='#fk'/></a>
  <a xlink:href='#issue_date' title='DATE '><text x='266' y='1631' >issue_date</text></a>
  <a xlink:href='#return_date' title='DATE '><text x='266' y='1645' >return_date</text></a>
  <a xlink:href='#borrower_type' title='VARCHAR&#040; 100 &#041; '><text x='266' y='1659' >borrower_type</text></a>
  <a xlink:href='#fine' title='INT '><text x='266' y='1673' >fine</text></a>

<!-- ============= Table 'residential_room' ============= -->
<rect class='table' x='266' y='1337' width='126' height='126' rx='7' ry='7' />
<path d='M 266.50 1358.00 L 266.50 1344.50 Q 266.50 1337.50 273.50 1337.50 L 384.50 1337.50 Q 391.50 1337.50 391.50 1344.50 L 391.50 1358.00 L266.50 1358.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#residential_room' title='college_db_schema.residential_room' ><text x='285' y='1351' class='tableTitle'>residential_room</text></a>
  <a xlink:href='#room_id' title='Primary Key  ( room_id ) '><use id='pk' x='268' y='1370' xlink:href='#pk'/></a>
<a xlink:href='#room_id' title='INT not null '><text x='280' y='1379' class='pk'>room_id</text></a>
<a xlink:href='#room_id' title='Referred by student_batch ( room_id ) '><use id='ref' x='378' y='1368' xlink:href='#ref'/></a>
  <a xlink:href='#residential_id' title='Index  ( residential_id ) '><use id='idx' x='268' y='1384' xlink:href='#idx'/></a>
<a xlink:href='#residential_id' title='INT '><text x='280' y='1393' class='fk'>residential_id</text></a>
<a xlink:href='#residential_id' title='References college_residential ( residential_id ) '><use id='fk' x='378' y='1382' xlink:href='#fk'/></a>
  <a xlink:href='#room_number' title='INT '><text x='280' y='1407' >room_number</text></a>
  <a xlink:href='#vacancy' title='BOOL '><text x='280' y='1421' >vacancy</text></a>
  <a xlink:href='#occupancy' title='INT '><text x='280' y='1435' >occupancy</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 100 &#041; '><text x='280' y='1449' >description</text></a>

<!-- ============= Table 'login_info' ============= -->
<rect class='table' x='252' y='1771' width='196' height='154' rx='7' ry='7' />
<path d='M 252.50 1792.00 L 252.50 1778.50 Q 252.50 1771.50 259.50 1771.50 L 440.50 1771.50 Q 447.50 1771.50 447.50 1778.50 L 447.50 1792.00 L252.50 1792.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#login_info' title='college_db_schema.login_info' ><text x='323' y='1785' class='tableTitle'>login_info</text></a>
  <a xlink:href='#login_id' title='Index  ( login_id ) '><use id='idx' x='254' y='1804' xlink:href='#idx'/></a>
<a xlink:href='#login_id' title='VARCHAR&#040; 100 &#041; '><text x='266' y='1813' class='fk'>login_id</text></a>
<a xlink:href='#login_id' title='References student_details ( login_id -> email_id ) '><use id='fk' x='434' y='1802' xlink:href='#fk'/></a>
  <a xlink:href='#password' title='VARCHAR&#040; 20 &#041; '><text x='266' y='1827' >password</text></a>
  <a xlink:href='#college_id' title='INT '><text x='266' y='1841' >college_id</text></a>
  <a xlink:href='#last_login_time' title='TIMESTAMP '><text x='266' y='1855' >last_login_time</text></a>
  <a xlink:href='#last_password_update_time' title='TIMESTAMP '><text x='266' y='1869' >last_password_update_time</text></a>
  <a xlink:href='#security_question' title='VARCHAR&#040; 50 &#041; '><text x='266' y='1883' >security_question</text></a>
  <a xlink:href='#security_question_answer' title='VARCHAR&#040; 100 &#041; '><text x='266' y='1897' >security_question_answer</text></a>
  <a xlink:href='#user_type' title='VARCHAR&#040; 30 &#041; '><text x='266' y='1911' >user_type</text></a>

<!-- ============= Table 'group_member' ============= -->
<rect class='table' x='994' y='847' width='140' height='126' rx='7' ry='7' />
<path d='M 994.50 868.00 L 994.50 854.50 Q 994.50 847.50 1001.50 847.50 L 1126.50 847.50 Q 1133.50 847.50 1133.50 854.50 L 1133.50 868.00 L994.50 868.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#group_member' title='college_db_schema.group_member' ><text x='1024' y='861' class='tableTitle'>group_member</text></a>
  <a xlink:href='#group_id' title='Unique Index  ( group_id ) '><use id='unq' x='996' y='880' xlink:href='#unq'/></a>
<a xlink:href='#group_id' title='INT '><text x='1008' y='889' class='fk'>group_id</text></a>
<a xlink:href='#group_id' title='References group ( group_id ) Referred by group_update ( member_id -> group_id ) Referred by group_update ( member_id -> group_id ) '><use id='ref' x='1120' y='878' xlink:href='#ref'/></a>
  <a xlink:href='#member_id' title='Index  ( member_id ) '><use id='idx' x='996' y='894' xlink:href='#idx'/></a>
<a xlink:href='#member_id' title='INT not null '><text x='1008' y='903' class='fk'>member_id</text></a>
<a xlink:href='#member_id' title='References student_batch ( member_id -> student_batch_id ) References college_staff ( member_id -> staff_id ) '><use id='fk' x='1120' y='892' xlink:href='#fk'/></a>
  <a xlink:href='#add_date' title='DATE not null '><text x='1008' y='917' >add_date</text></a>
  <a xlink:href='#leave_date' title='DATE '><text x='1008' y='931' >leave_date</text></a>
  <a xlink:href='#last_update)date' title='DATE '><text x='1008' y='945' >last_update)date</text></a>
  <a xlink:href='#added_by_id' title='Index  ( added_by_id ) '><use id='idx' x='996' y='950' xlink:href='#idx'/></a>
<a xlink:href='#added_by_id' title='INT '><text x='1008' y='959' class='fk'>added_by_id</text></a>
<a xlink:href='#added_by_id' title='References student_batch ( added_by_id -> student_batch_id ) References college_staff ( added_by_id -> staff_id ) '><use id='fk' x='1120' y='948' xlink:href='#fk'/></a>

<!-- ============= Table 'library_book_details' ============= -->
<rect class='table' x='42' y='1407' width='126' height='154' rx='7' ry='7' />
<path d='M 42.50 1428.00 L 42.50 1414.50 Q 42.50 1407.50 49.50 1407.50 L 160.50 1407.50 Q 167.50 1407.50 167.50 1414.50 L 167.50 1428.00 L42.50 1428.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#library_book_details' title='college_db_schema.library_book_details' ><text x='52' y='1421' class='tableTitle'>library_book_details</text></a>
  <a xlink:href='#book_id' title='Primary Key  ( book_id ) '><use id='pk' x='44' y='1440' xlink:href='#pk'/></a>
<a xlink:href='#book_id' title='INT not null '><text x='56' y='1449' class='pk'>book_id</text></a>
<a xlink:href='#book_id' title='Referred by student_book_borrow ( book_id ) '><use id='ref' x='154' y='1438' xlink:href='#ref'/></a>
  <a xlink:href='#author_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1463' >author_name</text></a>
  <a xlink:href='#book_name' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1477' >book_name</text></a>
  <a xlink:href='#category' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1491' >category</text></a>
  <a xlink:href='#price' title='INT '><text x='56' y='1505' >price</text></a>
  <a xlink:href='#publisher' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1519' >publisher</text></a>
  <a xlink:href='#referred_by' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1533' >referred_by</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='56' y='1547' >description</text></a>

<!-- ============= Table 'college_staff' ============= -->
<rect class='table' x='42' y='1575' width='126' height='210' rx='7' ry='7' />
<path d='M 42.50 1596.00 L 42.50 1582.50 Q 42.50 1575.50 49.50 1575.50 L 160.50 1575.50 Q 167.50 1575.50 167.50 1582.50 L 167.50 1596.00 L42.50 1596.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#college_staff' title='college_db_schema.college_staff' ><text x='72' y='1589' class='tableTitle'>college_staff</text></a>
  <a xlink:href='#staff_id' title='Primary Key  ( staff_id ) '><use id='pk' x='44' y='1608' xlink:href='#pk'/></a>
<a xlink:href='#staff_id' title='INT not null '><text x='56' y='1617' class='pk'>staff_id</text></a>
<a xlink:href='#staff_id' title='Referred by professor_details ( professor_id -> staff_id ) Referred by professor_department ( professor_id -> staff_id ) Referred by college_staff_financial ( staff_id ) Referred by college_staff_financial ( staff_id ) Referred by document_upload ( uploader_id -> staff_id ) Referred by document_upload ( uploader_id -> staff_id ) Referred by group ( owner_id -> staff_id ) Referred by group ( owner_id -> staff_id ) Referred by group_member ( member_id -> staff_id ) Referred by group_member ( added_by_id -> staff_id ) Referred by group_member ( member_id -> staff_id ) Referred by group_member ( added_by_id -> staff_id ) Referred by message ( sender_id -> staff_id ) Referred by message ( receiver_id -> staff_id ) Referred by message ( sender_id -> staff_id ) Referred by message ( receiver_id -> staff_id ) Referred by course_professor ( professor_id_1 -> staff_id ) Referred by course_professor ( professor_id_2 -> staff_id ) Referred by course_professor ( professor_id_1 -> staff_id ) Referred by course_professor ( professor_id_3 -> staff_id ) Referred by course_professor ( professor_id_4 -> staff_id ) Referred by course_professor ( visiting_id -> staff_id ) Referred by course_professor ( professor_id_1 -> staff_id ) Referred by course_professor ( professor_id_2 -> staff_id ) Referred by course_professor ( professor_id_3 -> staff_id ) Referred by course_professor ( professor_id_4 -> staff_id ) Referred by course_professor ( visiting_id -> staff_id ) Referred by professor_work ( professor_id -> staff_id ) Referred by professor_work ( professor_id -> staff_id ) Referred by student_course_project ( professor_id -> staff_id ) Referred by student_course_project ( professor_id -> staff_id ) Referred by connections ( user_connection_id -> staff_id ) Referred by connections ( user_connection_id -> staff_id ) Referred by connections ( user_connection_id -> staff_id ) Referred by connections ( user_connection_id -> staff_id ) Referred by connections ( user_id -> staff_id ) Referred by connections ( user_id -> staff_id ) Referred by connections ( user_id -> staff_id ) Referred by follow ( follower_id -> staff_id ) Referred by follow ( follower_id -> staff_id ) Referred by posts ( posted_by_id -> staff_id ) '><use id='ref' x='154' y='1606' xlink:href='#ref'/></a>
  <a xlink:href='#staff_name' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='1631' >staff_name</text></a>
  <a xlink:href='#designation' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='1645' >designation</text></a>
  <a xlink:href='#joining_date' title='DATE not null '><text x='56' y='1659' >joining_date</text></a>
  <a xlink:href='#phone_number' title='VARCHAR&#040; 20 &#041; not null '><text x='56' y='1673' >phone_number</text></a>
  <a xlink:href='#address_line' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1687' >address_line</text></a>
  <a xlink:href='#city' title='VARCHAR&#040; 50 &#041; '><text x='56' y='1701' >city</text></a>
  <a xlink:href='#state' title='VARCHAR&#040; 50 &#041; '><text x='56' y='1715' >state</text></a>
  <a xlink:href='#country' title='VARCHAR&#040; 30 &#041; '><text x='56' y='1729' >country</text></a>
  <a xlink:href='#email_id' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1743' >email_id</text></a>
  <a xlink:href='#staff_type' title='BOOL not null '><text x='56' y='1757' >staff_type</text></a>
  <a xlink:href='#role' title='VARCHAR&#040; 100 &#041; '><text x='56' y='1771' >role</text></a>

<!-- ============= Table 'student_course' ============= -->
<rect class='table' x='294' y='567' width='140' height='126' rx='7' ry='7' />
<path d='M 294.50 588.00 L 294.50 574.50 Q 294.50 567.50 301.50 567.50 L 426.50 567.50 Q 433.50 567.50 433.50 574.50 L 433.50 588.00 L294.50 588.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_course' title='college_db_schema.student_course' ><text x='325' y='581' class='tableTitle'>student_course</text></a>
  <a xlink:href='#student_course_id' title='Primary Key  ( student_course_id ) '><use id='pk' x='296' y='600' xlink:href='#pk'/></a>
<a xlink:href='#student_course_id' title='INT not null '><text x='308' y='609' class='pk'>student_course_id</text></a>
<a xlink:href='#student_course_id' title='Referred by student_course_project ( student_course_id ) '><use id='ref' x='420' y='598' xlink:href='#ref'/></a>
  <a xlink:href='#student_id' title='Index  ( student_id ) '><use id='idx' x='296' y='614' xlink:href='#idx'/></a>
<a xlink:href='#student_id' title='INT '><text x='308' y='623' class='fk'>student_id</text></a>
<a xlink:href='#student_id' title='References student_details ( student_id ) '><use id='fk' x='420' y='612' xlink:href='#fk'/></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='296' y='628' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='308' y='637' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='420' y='626' xlink:href='#fk'/></a>
  <a xlink:href='#degree_course_id' title='Index  ( degree_course_id ) '><use id='idx' x='296' y='642' xlink:href='#idx'/></a>
<a xlink:href='#degree_course_id' title='INT '><text x='308' y='651' class='fk'>degree_course_id</text></a>
<a xlink:href='#degree_course_id' title='References degree_course ( degree_course_id ) '><use id='fk' x='420' y='640' xlink:href='#fk'/></a>
  <a xlink:href='#marks' title='INT '><text x='308' y='665' >marks</text></a>
  <a xlink:href='#grade' title='VARCHAR&#040; 10 &#041; '><text x='308' y='679' >grade</text></a>

<!-- ============= Table 'student_batch' ============= -->
<rect class='table' x='336' y='777' width='168' height='140' rx='7' ry='7' />
<path d='M 336.50 798.00 L 336.50 784.50 Q 336.50 777.50 343.50 777.50 L 496.50 777.50 Q 503.50 777.50 503.50 784.50 L 503.50 798.00 L336.50 798.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_batch' title='college_db_schema.student_batch' ><text x='383' y='791' class='tableTitle'>student_batch</text></a>
  <a xlink:href='#student_batch_id' title='Primary Key  ( student_batch_id ) '><use id='pk' x='338' y='810' xlink:href='#pk'/></a>
<a xlink:href='#student_batch_id' title='INT not null '><text x='350' y='819' class='pk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='Referred by student_finance_one_time ( student_batch_id ) Referred by student_financial_semester_wise ( student_batch_id ) Referred by placements ( student_batch_id ) Referred by student_placed ( student_batch_id ) Referred by student_resume ( student_batch_id ) Referred by student_resume ( student_batch_id ) Referred by student_connections ( user_id -> student_batch_id ) Referred by connections ( user_id -> student_batch_id ) Referred by follow ( follower_id -> student_batch_id ) Referred by follow ( follower_id -> student_batch_id ) Referred by follow ( follower_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by follow ( follower_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by follow ( follower_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by follow ( following_id -> student_batch_id ) Referred by document_upload ( uploader_id -> student_batch_id ) Referred by document_upload ( uploader_id -> student_batch_id ) Referred by document_upload ( uploader_id -> student_batch_id ) Referred by group ( owner_id -> student_batch_id ) Referred by group ( owner_id -> student_batch_id ) Referred by group_member ( member_id -> student_batch_id ) Referred by group_member ( member_id -> student_batch_id ) Referred by group_member ( added_by_id -> student_batch_id ) Referred by group_member ( added_by_id -> student_batch_id ) Referred by group_member ( member_id -> student_batch_id ) Referred by group_member ( added_by_id -> student_batch_id ) Referred by message ( sender_id -> student_batch_id ) Referred by message ( sender_id -> student_batch_id ) Referred by message ( receiver_id -> student_batch_id ) Referred by message ( receiver_id -> student_batch_id ) Referred by message ( sender_id -> student_batch_id ) Referred by message ( receiver_id -> student_batch_id ) Referred by student_result ( student_id -> student_batch_id ) Referred by student_result ( student_id -> student_batch_id ) Referred by connections ( user_connection_id -> student_batch_id ) Referred by connections ( user_id -> student_batch_id ) Referred by connections ( user_connection_id -> student_batch_id ) Referred by connections ( user_id -> student_batch_id ) Referred by connections ( connection_id -> student_batch_id ) Referred by connections ( connection_id -> student_batch_id ) Referred by posts ( posted_by_id -> student_batch_id ) Referred by posts ( posted_by_id -> student_batch_id ) '><use id='ref' x='490' y='808' xlink:href='#ref'/></a>
  <a xlink:href='#student_id' title='Index  ( student_id ) '><use id='idx' x='338' y='824' xlink:href='#idx'/></a>
<a xlink:href='#student_id' title='INT '><text x='350' y='833' class='fk'>student_id</text></a>
<a xlink:href='#student_id' title='References student_details ( student_id ) '><use id='fk' x='490' y='822' xlink:href='#fk'/></a>
  <a xlink:href='#batch_id' title='Index  ( batch_id ) '><use id='idx' x='338' y='838' xlink:href='#idx'/></a>
<a xlink:href='#batch_id' title='INT '><text x='350' y='847' class='fk'>batch_id</text></a>
<a xlink:href='#batch_id' title='References batch_details ( batch_id ) '><use id='fk' x='490' y='836' xlink:href='#fk'/></a>
  <a xlink:href='#degree_department_id' title='Index  ( degree_department_id ) '><use id='idx' x='338' y='852' xlink:href='#idx'/></a>
<a xlink:href='#degree_department_id' title='INT '><text x='350' y='861' class='fk'>degree_department_id</text></a>
<a xlink:href='#degree_department_id' title='References degree_department ( degree_department_id ) '><use id='fk' x='490' y='850' xlink:href='#fk'/></a>
  <a xlink:href='#start_year' title='INT '><text x='350' y='875' >start_year</text></a>
  <a xlink:href='#end_year' title='INT '><text x='350' y='889' >end_year</text></a>
  <a xlink:href='#room_id' title='Index  ( room_id ) '><use id='idx' x='338' y='894' xlink:href='#idx'/></a>
<a xlink:href='#room_id' title='INT '><text x='350' y='903' class='fk'>room_id</text></a>
<a xlink:href='#room_id' title='References residential_room ( room_id ) '><use id='fk' x='490' y='892' xlink:href='#fk'/></a>

<!-- ============= Table 'student_finance_one_time' ============= -->
<rect class='table' x='350' y='1057' width='154' height='140' rx='7' ry='7' />
<path d='M 350.50 1078.00 L 350.50 1064.50 Q 350.50 1057.50 357.50 1057.50 L 496.50 1057.50 Q 503.50 1057.50 503.50 1064.50 L 503.50 1078.00 L350.50 1078.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_finance_one_time' title='college_db_schema.student_finance_one_time' ><text x='358' y='1071' class='tableTitle'>student_finance_one_time</text></a>
  <a xlink:href='#student_batch_id' title='Index  ( student_batch_id ) '><use id='idx' x='352' y='1090' xlink:href='#idx'/></a>
<a xlink:href='#student_batch_id' title='INT '><text x='364' y='1099' class='fk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='References student_batch ( student_batch_id ) '><use id='fk' x='490' y='1088' xlink:href='#fk'/></a>
  <a xlink:href='#caution_fee' title='INT '><text x='364' y='1113' >caution_fee</text></a>
  <a xlink:href='#admission_fee' title='INT '><text x='364' y='1127' >admission_fee</text></a>
  <a xlink:href='#other_fee' title='INT '><text x='364' y='1141' >other_fee</text></a>
  <a xlink:href='#total_payment' title='INT '><text x='364' y='1155' >total_payment</text></a>
  <a xlink:href='#fine' title='INT '><text x='364' y='1169' >fine</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='364' y='1183' >description</text></a>

<!-- ============= Table 'group_update' ============= -->
<rect class='table' x='574' y='665' width='140' height='126' rx='7' ry='7' />
<path d='M 574.50 686.00 L 574.50 672.50 Q 574.50 665.50 581.50 665.50 L 706.50 665.50 Q 713.50 665.50 713.50 672.50 L 713.50 686.00 L574.50 686.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#group_update' title='college_db_schema.group_update' ><text x='608' y='679' class='tableTitle'>group_update</text></a>
  <a xlink:href='#group_id' title='Index  ( group_id ) '><use id='idx' x='576' y='698' xlink:href='#idx'/></a>
<a xlink:href='#group_id' title='INT not null '><text x='588' y='707' class='fk'>group_id</text></a>
<a xlink:href='#group_id' title='References group ( group_id ) '><use id='fk' x='700' y='696' xlink:href='#fk'/></a>
  <a xlink:href='#update_id' title='INT '><text x='588' y='721' >update_id</text></a>
  <a xlink:href='#member_id' title='Index  ( member_id ) '><use id='idx' x='576' y='726' xlink:href='#idx'/></a>
<a xlink:href='#member_id' title='INT not null '><text x='588' y='735' class='fk'>member_id</text></a>
<a xlink:href='#member_id' title='References group_member ( member_id -> group_id ) '><use id='fk' x='700' y='724' xlink:href='#fk'/></a>
  <a xlink:href='#parent_update_id' title='INT '><text x='588' y='749' >parent_update_id</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='588' y='763' >description</text></a>
  <a xlink:href='#document_id' title='Index  ( document_id ) '><use id='idx' x='576' y='768' xlink:href='#idx'/></a>
<a xlink:href='#document_id' title='INT '><text x='588' y='777' class='fk'>document_id</text></a>
<a xlink:href='#document_id' title='References document_upload ( document_id ) '><use id='fk' x='700' y='766' xlink:href='#fk'/></a>

<!-- ============= Table 'degree_management' ============= -->
<rect class='table' x='812' y='637' width='154' height='126' rx='7' ry='7' />
<path d='M 812.50 658.00 L 812.50 644.50 Q 812.50 637.50 819.50 637.50 L 958.50 637.50 Q 965.50 637.50 965.50 644.50 L 965.50 658.00 L812.50 658.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#degree_management' title='college_db_schema.degree_management' ><text x='834' y='651' class='tableTitle'>degree_management</text></a>
  <a xlink:href='#degree_id' title='Index  ( degree_id ) '><use id='idx' x='814' y='670' xlink:href='#idx'/></a>
<a xlink:href='#degree_id' title='INT '><text x='826' y='679' class='fk'>degree_id</text></a>
<a xlink:href='#degree_id' title='References degree_details ( degree_id ) '><use id='fk' x='952' y='668' xlink:href='#fk'/></a>
  <a xlink:href='#degree_incharge_id' title='INT not null '><text x='826' y='693' >degree_incharge_id</text></a>
  <a xlink:href='#batch_id' title='Index  ( batch_id ) '><use id='idx' x='814' y='698' xlink:href='#idx'/></a>
<a xlink:href='#batch_id' title='INT '><text x='826' y='707' class='fk'>batch_id</text></a>
<a xlink:href='#batch_id' title='References batch_details ( batch_id ) '><use id='fk' x='952' y='696' xlink:href='#fk'/></a>
  <a xlink:href='#incharge_start_date' title='DATE not null '><text x='826' y='721' >incharge_start_date</text></a>
  <a xlink:href='#incharge_end_date' title='DATE '><text x='826' y='735' >incharge_end_date</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='826' y='749' >description</text></a>

<!-- ============= Table 'student_financial_semester_wise' ============= -->
<rect class='table' x='588' y='903' width='182' height='196' rx='7' ry='7' />
<path d='M 588.50 924.00 L 588.50 910.50 Q 588.50 903.50 595.50 903.50 L 762.50 903.50 Q 769.50 903.50 769.50 910.50 L 769.50 924.00 L588.50 924.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_financial_semester_wise' title='college_db_schema.student_financial_semester_wise' ><text x='594' y='917' class='tableTitle'>student_financial_semester_wise</text></a>
  <a xlink:href='#student_batch_id' title='Index  ( student_batch_id ) '><use id='idx' x='590' y='936' xlink:href='#idx'/></a>
<a xlink:href='#student_batch_id' title='INT '><text x='602' y='945' class='fk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='References student_batch ( student_batch_id ) '><use id='fk' x='756' y='934' xlink:href='#fk'/></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='590' y='950' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='602' y='959' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='756' y='948' xlink:href='#fk'/></a>
  <a xlink:href='#tuition_fee' title='INT '><text x='602' y='973' >tuition_fee</text></a>
  <a xlink:href='#library_fee' title='INT '><text x='602' y='987' >library_fee</text></a>
  <a xlink:href='#hostel_fee' title='INT '><text x='602' y='1001' >hostel_fee</text></a>
  <a xlink:href='#mess_fee' title='INT '><text x='602' y='1015' >mess_fee</text></a>
  <a xlink:href='#other_fee' title='INT '><text x='602' y='1029' >other_fee</text></a>
  <a xlink:href='#total_payment' title='INT '><text x='602' y='1043' >total_payment</text></a>
  <a xlink:href='#payment_date' title='DATE '><text x='602' y='1057' >payment_date</text></a>
  <a xlink:href='#receipt_number' title='VARCHAR&#040; 50 &#041; '><text x='602' y='1071' >receipt_number</text></a>
  <a xlink:href='#fine' title='INT '><text x='602' y='1085' >fine</text></a>

<!-- ============= Table 'student_placed' ============= -->
<rect class='table' x='490' y='1295' width='140' height='98' rx='7' ry='7' />
<path d='M 490.50 1316.00 L 490.50 1302.50 Q 490.50 1295.50 497.50 1295.50 L 622.50 1295.50 Q 629.50 1295.50 629.50 1302.50 L 629.50 1316.00 L490.50 1316.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_placed' title='college_db_schema.student_placed' ><text x='520' y='1309' class='tableTitle'>student_placed</text></a>
  <a xlink:href='#student_batch_id' title='Index  ( student_batch_id ) '><use id='idx' x='492' y='1328' xlink:href='#idx'/></a>
<a xlink:href='#student_batch_id' title='INT '><text x='504' y='1337' class='fk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='References student_batch ( student_batch_id ) '><use id='fk' x='616' y='1326' xlink:href='#fk'/></a>
  <a xlink:href='#company_id' title='INT '><text x='504' y='1351' class='fk'>company_id</text></a>
<a xlink:href='#company_id' title='References placements ( company_id ) '><use id='fk' x='616' y='1340' xlink:href='#fk'/></a>
  <a xlink:href='#internship' title='BOOL '><text x='504' y='1365' >internship</text></a>
  <a xlink:href='#regular' title='BOOL '><text x='504' y='1379' >regular</text></a>

<!-- ============= Table 'student_profile_picture' ============= -->
<rect class='table' x='616' y='1169' width='140' height='70' rx='7' ry='7' />
<path d='M 616.50 1190.00 L 616.50 1176.50 Q 616.50 1169.50 623.50 1169.50 L 748.50 1169.50 Q 755.50 1169.50 755.50 1176.50 L 755.50 1190.00 L616.50 1190.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_profile_picture' title='college_db_schema.student_profile_picture' ><text x='626' y='1183' class='tableTitle'>student_profile_picture</text></a>
  <a xlink:href='#user_id' title='Index  ( user_id ) '><use id='idx' x='618' y='1202' xlink:href='#idx'/></a>
<a xlink:href='#user_id' title='INT '><text x='630' y='1211' class='fk'>user_id</text></a>
<a xlink:href='#user_id' title='References student_details ( user_id -> student_id ) '><use id='fk' x='742' y='1200' xlink:href='#fk'/></a>
  <a xlink:href='#profile_picture' title='BLOB '><text x='630' y='1225' >profile_picture</text></a>

<!-- ============= Table 'student_course_project' ============= -->
<rect class='table' x='56' y='1827' width='154' height='168' rx='7' ry='7' />
<path d='M 56.50 1848.00 L 56.50 1834.50 Q 56.50 1827.50 63.50 1827.50 L 202.50 1827.50 Q 209.50 1827.50 209.50 1834.50 L 209.50 1848.00 L56.50 1848.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_course_project' title='college_db_schema.student_course_project' ><text x='73' y='1841' class='tableTitle'>student_course_project</text></a>
  <a xlink:href='#course_project_id' title='Primary Key  ( course_project_id ) '><use id='pk' x='58' y='1860' xlink:href='#pk'/></a>
<a xlink:href='#course_project_id' title='INT not null '><text x='70' y='1869' class='pk'>course_project_id</text></a>
  <a xlink:href='#course_project_name' title='VARCHAR&#040; 100 &#041; not null '><text x='70' y='1883' >course_project_name</text></a>
  <a xlink:href='#student_course_id' title='Index  ( student_course_id ) '><use id='idx' x='58' y='1888' xlink:href='#idx'/></a>
<a xlink:href='#student_course_id' title='INT '><text x='70' y='1897' class='fk'>student_course_id</text></a>
<a xlink:href='#student_course_id' title='References student_course ( student_course_id ) '><use id='fk' x='196' y='1886' xlink:href='#fk'/></a>
  <a xlink:href='#abstract' title='VARCHAR&#040; 500 &#041; '><text x='70' y='1911' >abstract</text></a>
  <a xlink:href='#professor_id' title='Index  ( professor_id ) '><use id='idx' x='58' y='1916' xlink:href='#idx'/></a>
<a xlink:href='#professor_id' title='INT '><text x='70' y='1925' class='fk'>professor_id</text></a>
<a xlink:href='#professor_id' title='References college_staff ( professor_id -> staff_id ) '><use id='fk' x='196' y='1914' xlink:href='#fk'/></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='58' y='1930' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='70' y='1939' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='196' y='1928' xlink:href='#fk'/></a>
  <a xlink:href='#recognition' title='VARCHAR&#040; 100 &#041; '><text x='70' y='1953' >recognition</text></a>
  <a xlink:href='#technology_used' title='VARCHAR&#040; 100 &#041; '><text x='70' y='1967' >technology_used</text></a>
  <a xlink:href='#skill_used' title='VARCHAR&#040; 100 &#041; '><text x='70' y='1981' >skill_used</text></a>

<!-- ============= Table 'student_result' ============= -->
<rect class='table' x='490' y='1449' width='154' height='168' rx='7' ry='7' />
<path d='M 490.50 1470.00 L 490.50 1456.50 Q 490.50 1449.50 497.50 1449.50 L 636.50 1449.50 Q 643.50 1449.50 643.50 1456.50 L 643.50 1470.00 L490.50 1470.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_result' title='college_db_schema.student_result' ><text x='530' y='1463' class='tableTitle'>student_result</text></a>
  <a xlink:href='#student_id' title='Index  ( student_id ) '><use id='idx' x='492' y='1482' xlink:href='#idx'/></a>
<a xlink:href='#student_id' title='INT '><text x='504' y='1491' class='fk'>student_id</text></a>
<a xlink:href='#student_id' title='References student_batch ( student_id -> student_batch_id ) '><use id='fk' x='630' y='1480' xlink:href='#fk'/></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='492' y='1496' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='504' y='1505' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='630' y='1494' xlink:href='#fk'/></a>
  <a xlink:href='#course_professor_id' title='Index  ( course_professor_id ) '><use id='idx' x='492' y='1510' xlink:href='#idx'/></a>
<a xlink:href='#course_professor_id' title='INT '><text x='504' y='1519' class='fk'>course_professor_id</text></a>
<a xlink:href='#course_professor_id' title='References course_professor ( course_professor_id ) '><use id='fk' x='630' y='1508' xlink:href='#fk'/></a>
  <a xlink:href='#final_grade' title='VARCHAR&#040; 10 &#041; '><text x='504' y='1533' >final_grade</text></a>
  <a xlink:href='#attendance' title='INT '><text x='504' y='1547' >attendance</text></a>
  <a xlink:href='#theory_grade' title='VARCHAR&#040; 10 &#041; '><text x='504' y='1561' >theory_grade</text></a>
  <a xlink:href='#practical_grade' title='VARCHAR&#040; 10 &#041; '><text x='504' y='1575' >practical_grade</text></a>
  <a xlink:href='#result' title='VARCHAR&#040; 20 &#041; '><text x='504' y='1589' >result</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='504' y='1603' >description</text></a>

<!-- ============= Table 'course_professor' ============= -->
<rect class='table' x='798' y='1379' width='154' height='210' rx='7' ry='7' />
<path d='M 798.50 1400.00 L 798.50 1386.50 Q 798.50 1379.50 805.50 1379.50 L 944.50 1379.50 Q 951.50 1379.50 951.50 1386.50 L 951.50 1400.00 L798.50 1400.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#course_professor' title='college_db_schema.course_professor' ><text x='831' y='1393' class='tableTitle'>course_professor</text></a>
  <a xlink:href='#course_professor_id' title='Primary Key  ( course_professor_id ) '><use id='pk' x='800' y='1412' xlink:href='#pk'/></a>
<a xlink:href='#course_professor_id' title='INT not null '><text x='812' y='1421' class='pk'>course_professor_id</text></a>
<a xlink:href='#course_professor_id' title='Referred by student_result ( course_professor_id ) Referred by student_result ( course_professor_id ) '><use id='ref' x='938' y='1410' xlink:href='#ref'/></a>
  <a xlink:href='#course_id' title='Index  ( course_id ) '><use id='idx' x='800' y='1426' xlink:href='#idx'/></a>
<a xlink:href='#course_id' title='INT '><text x='812' y='1435' class='fk'>course_id</text></a>
<a xlink:href='#course_id' title='References course_details ( course_id ) '><use id='fk' x='938' y='1424' xlink:href='#fk'/></a>
  <a xlink:href='#professor_id_1' title='Index  ( professor_id_1 ) '><use id='idx' x='800' y='1440' xlink:href='#idx'/></a>
<a xlink:href='#professor_id_1' title='INT '><text x='812' y='1449' class='fk'>professor_id_1</text></a>
<a xlink:href='#professor_id_1' title='References college_staff ( professor_id_1 -> staff_id ) '><use id='fk' x='938' y='1438' xlink:href='#fk'/></a>
  <a xlink:href='#professor_id_2' title='Index  ( professor_id_2 ) '><use id='idx' x='800' y='1454' xlink:href='#idx'/></a>
<a xlink:href='#professor_id_2' title='INT '><text x='812' y='1463' class='fk'>professor_id_2</text></a>
<a xlink:href='#professor_id_2' title='References college_staff ( professor_id_2 -> staff_id ) '><use id='fk' x='938' y='1452' xlink:href='#fk'/></a>
  <a xlink:href='#professor_id_3' title='Index  ( professor_id_3 ) '><use id='idx' x='800' y='1468' xlink:href='#idx'/></a>
<a xlink:href='#professor_id_3' title='INT '><text x='812' y='1477' class='fk'>professor_id_3</text></a>
<a xlink:href='#professor_id_3' title='References college_staff ( professor_id_3 -> staff_id ) '><use id='fk' x='938' y='1466' xlink:href='#fk'/></a>
  <a xlink:href='#professor_id_4' title='Index  ( professor_id_4 ) '><use id='idx' x='800' y='1482' xlink:href='#idx'/></a>
<a xlink:href='#professor_id_4' title='INT '><text x='812' y='1491' class='fk'>professor_id_4</text></a>
<a xlink:href='#professor_id_4' title='References college_staff ( professor_id_4 -> staff_id ) '><use id='fk' x='938' y='1480' xlink:href='#fk'/></a>
  <a xlink:href='#start_date' title='DATE '><text x='812' y='1505' >start_date</text></a>
  <a xlink:href='#end_date' title='DATE '><text x='812' y='1519' >end_date</text></a>
  <a xlink:href='#lecture_duration' title='INT '><text x='812' y='1533' >lecture_duration</text></a>
  <a xlink:href='#batch_id' title='INT '><text x='812' y='1547' >batch_id</text></a>
  <a xlink:href='#status' title='VARCHAR&#040; 10 &#041; '><text x='812' y='1561' >status</text></a>
  <a xlink:href='#visiting_id' title='Index  ( visiting_id ) '><use id='idx' x='800' y='1566' xlink:href='#idx'/></a>
<a xlink:href='#visiting_id' title='INT '><text x='812' y='1575' class='fk'>visiting_id</text></a>
<a xlink:href='#visiting_id' title='References college_staff ( visiting_id -> staff_id ) '><use id='fk' x='938' y='1564' xlink:href='#fk'/></a>

<!-- ============= Table 'student_resume' ============= -->
<rect class='table' x='770' y='1645' width='140' height='126' rx='7' ry='7' />
<path d='M 770.50 1666.00 L 770.50 1652.50 Q 770.50 1645.50 777.50 1645.50 L 902.50 1645.50 Q 909.50 1645.50 909.50 1652.50 L 909.50 1666.00 L770.50 1666.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#student_resume' title='college_db_schema.student_resume' ><text x='799' y='1659' class='tableTitle'>student_resume</text></a>
  <a xlink:href='#resume_id' title='Primary Key  ( resume_id ) '><use id='pk' x='772' y='1678' xlink:href='#pk'/></a>
<a xlink:href='#resume_id' title='INT not null '><text x='784' y='1687' class='pk'>resume_id</text></a>
  <a xlink:href='#student_batch_id' title='Index  ( student_batch_id ) '><use id='idx' x='772' y='1692' xlink:href='#idx'/></a>
<a xlink:href='#student_batch_id' title='INT not null '><text x='784' y='1701' class='fk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='References student_batch ( student_batch_id ) '><use id='fk' x='896' y='1690' xlink:href='#fk'/></a>
  <a xlink:href='#title' title='VARCHAR&#040; 100 &#041; not null '><text x='784' y='1715' >title</text></a>
  <a xlink:href='#url' title='VARCHAR&#040; 200 &#041; '><text x='784' y='1729' >url</text></a>
  <a xlink:href='#most_recent' title='BOOL not null '><text x='784' y='1743' >most_recent</text></a>
  <a xlink:href='#upload_date' title='DATE not null '><text x='784' y='1757' >upload_date</text></a>

<!-- ============= Table 'document_upload' ============= -->
<rect class='table' x='504' y='1855' width='140' height='98' rx='7' ry='7' />
<path d='M 504.50 1876.00 L 504.50 1862.50 Q 504.50 1855.50 511.50 1855.50 L 636.50 1855.50 Q 643.50 1855.50 643.50 1862.50 L 643.50 1876.00 L504.50 1876.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#document_upload' title='college_db_schema.document_upload this will map all the documents uploaded with the uploader id&#046; for example&#044;
if a student uploads a document in DB course&#044; then that document entry will
first be stored in this table&#044; then it will be used everywhere using this document&#095;id' ><text x='527' y='1869' class='tableTitle'>document_upload</text></a>
  <a xlink:href='#document_id' title='Primary Key  ( document_id ) '><use id='pk' x='506' y='1888' xlink:href='#pk'/></a>
<a xlink:href='#document_id' title='INT not null '><text x='518' y='1897' class='pk'>document_id</text></a>
<a xlink:href='#document_id' title='Referred by group_update ( document_id ) Referred by group_update ( document_id ) Referred by message ( attachment_id -> document_id ) Referred by message ( attachment_id -> document_id ) '><use id='ref' x='630' y='1886' xlink:href='#ref'/></a>
  <a xlink:href='#uploader_id' title='Index  ( uploader_id ) '><use id='idx' x='506' y='1902' xlink:href='#idx'/></a>
<a xlink:href='#uploader_id' title='INT '><text x='518' y='1911' class='fk'>uploader_id</text></a>
<a xlink:href='#uploader_id' title='References student_batch ( uploader_id -> student_batch_id ) References college_staff ( uploader_id -> staff_id ) '><use id='fk' x='630' y='1900' xlink:href='#fk'/></a>
  <a xlink:href='#document_name' title='VARCHAR&#040; 100 &#041; '><text x='518' y='1925' >document_name</text></a>
  <a xlink:href='#upload_date' title='DATE '><text x='518' y='1939' >upload_date</text></a>

<!-- ============= Table 'placements' ============= -->
<rect class='table' x='1008' y='539' width='168' height='182' rx='7' ry='7' />
<path d='M 1008.50 560.00 L 1008.50 546.50 Q 1008.50 539.50 1015.50 539.50 L 1168.50 539.50 Q 1175.50 539.50 1175.50 546.50 L 1175.50 560.00 L1008.50 560.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#placements' title='college_db_schema.placements' ><text x='1062' y='553' class='tableTitle'>placements</text></a>
  <a xlink:href='#company_id' title='Primary Key  ( company_id ) '><use id='pk' x='1010' y='572' xlink:href='#pk'/></a>
<a xlink:href='#company_id' title='INT not null '><text x='1022' y='581' class='pk'>company_id</text></a>
<a xlink:href='#company_id' title='Referred by student_placed ( company_id ) '><use id='ref' x='1162' y='570' xlink:href='#ref'/></a>
  <a xlink:href='#company_name' title='VARCHAR&#040; 100 &#041; '><text x='1022' y='595' >company_name</text></a>
  <a xlink:href='#visit_date' title='DATE '><text x='1022' y='609' >visit_date</text></a>
  <a xlink:href='#visit_time' title='TIME '><text x='1022' y='623' >visit_time</text></a>
  <a xlink:href='#internship' title='BOOL '><text x='1022' y='637' >internship</text></a>
  <a xlink:href='#regular' title='BOOL '><text x='1022' y='651' >regular</text></a>
  <a xlink:href='#student_batch_id' title='Index  ( student_batch_id ) '><use id='idx' x='1010' y='656' xlink:href='#idx'/></a>
<a xlink:href='#student_batch_id' title='INT '><text x='1022' y='665' class='fk'>student_batch_id</text></a>
<a xlink:href='#student_batch_id' title='References student_batch ( student_batch_id ) '><use id='fk' x='1162' y='654' xlink:href='#fk'/></a>
  <a xlink:href='#package_offered' title='INT '><text x='1022' y='679' >package_offered</text></a>
  <a xlink:href='#job_description' title='VARCHAR&#040; 1000 &#041; '><text x='1022' y='693' >job_description</text></a>
  <a xlink:href='#student_placed_count' title='INT '><text x='1022' y='707' >student_placed_count</text></a>

<!-- ============= Table 'course_management' ============= -->
<rect class='table' x='518' y='259' width='126' height='154' rx='7' ry='7' />
<path d='M 518.50 280.00 L 518.50 266.50 Q 518.50 259.50 525.50 259.50 L 636.50 259.50 Q 643.50 259.50 643.50 266.50 L 643.50 280.00 L518.50 280.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#course_management' title='college_db_schema.course_management' ><text x='527' y='273' class='tableTitle'>course_management</text></a>
  <a xlink:href='#course_id' title='Index  ( course_id ) '><use id='idx' x='520' y='292' xlink:href='#idx'/></a>
<a xlink:href='#course_id' title='INT not null '><text x='532' y='301' class='fk'>course_id</text></a>
<a xlink:href='#course_id' title='References course_details ( course_id ) '><use id='fk' x='630' y='290' xlink:href='#fk'/></a>
  <a xlink:href='#batch_id' title='Index  ( batch_id ) '><use id='idx' x='520' y='306' xlink:href='#idx'/></a>
<a xlink:href='#batch_id' title='INT not null '><text x='532' y='315' class='fk'>batch_id</text></a>
<a xlink:href='#batch_id' title='References batch_details ( batch_id ) '><use id='fk' x='630' y='304' xlink:href='#fk'/></a>
  <a xlink:href='#capacity' title='INT not null '><text x='532' y='329' >capacity</text></a>
  <a xlink:href='#start_date' title='DATE not null '><text x='532' y='343' >start_date</text></a>
  <a xlink:href='#end_date' title='DATE '><text x='532' y='357' >end_date</text></a>
  <a xlink:href='#prerequisite' title='VARCHAR&#040; 200 &#041; '><text x='532' y='371' >prerequisite</text></a>
  <a xlink:href='#total_exams' title='INT '><text x='532' y='385' >total_exams</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='532' y='399' >description</text></a>

<!-- ============= Table 'professor_work' ============= -->
<rect class='table' x='1064' y='1407' width='140' height='154' rx='7' ry='7' />
<path d='M 1064.50 1428.00 L 1064.50 1414.50 Q 1064.50 1407.50 1071.50 1407.50 L 1196.50 1407.50 Q 1203.50 1407.50 1203.50 1414.50 L 1203.50 1428.00 L1064.50 1428.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#professor_work' title='college_db_schema.professor_work' ><text x='1093' y='1421' class='tableTitle'>professor_work</text></a>
  <a xlink:href='#professor_id' title='Index  ( professor_id ) '><use id='idx' x='1066' y='1440' xlink:href='#idx'/></a>
<a xlink:href='#professor_id' title='INT not null '><text x='1078' y='1449' class='fk'>professor_id</text></a>
<a xlink:href='#professor_id' title='References college_staff ( professor_id -> staff_id ) '><use id='fk' x='1190' y='1438' xlink:href='#fk'/></a>
  <a xlink:href='#course_id' title='Index  ( course_id ) '><use id='idx' x='1066' y='1454' xlink:href='#idx'/></a>
<a xlink:href='#course_id' title='INT '><text x='1078' y='1463' class='fk'>course_id</text></a>
<a xlink:href='#course_id' title='References course_details ( course_id ) '><use id='fk' x='1190' y='1452' xlink:href='#fk'/></a>
  <a xlink:href='#patent' title='VARCHAR&#040; 100 &#041; '><text x='1078' y='1477' >patent</text></a>
  <a xlink:href='#research' title='VARCHAR&#040; 200 &#041; '><text x='1078' y='1491' >research</text></a>
  <a xlink:href='#project' title='VARCHAR&#040; 100 &#041; '><text x='1078' y='1505' >project</text></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='1066' y='1510' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='1078' y='1519' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='1190' y='1508' xlink:href='#fk'/></a>
  <a xlink:href='#start_date' title='DATE '><text x='1078' y='1533' >start_date</text></a>
  <a xlink:href='#end_date' title='DATE '><text x='1078' y='1547' >end_date</text></a>

<!-- ============= Table 'group' ============= -->
<rect class='table' x='1064' y='1603' width='140' height='126' rx='7' ry='7' />
<path d='M 1064.50 1624.00 L 1064.50 1610.50 Q 1064.50 1603.50 1071.50 1603.50 L 1196.50 1603.50 Q 1203.50 1603.50 1203.50 1610.50 L 1203.50 1624.00 L1064.50 1624.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#group' title='college_db_schema.group' ><text x='1119' y='1617' class='tableTitle'>group</text></a>
  <a xlink:href='#group_id' title='Primary Key  ( group_id ) '><use id='pk' x='1066' y='1636' xlink:href='#pk'/></a>
<a xlink:href='#group_id' title='INT not null '><text x='1078' y='1645' class='pk'>group_id</text></a>
<a xlink:href='#group_id' title='Referred by group_member ( group_id ) Referred by group_member ( group_id ) Referred by group_update ( group_id ) Referred by group_update ( group_id ) Referred by group_update ( group_id ) '><use id='ref' x='1190' y='1634' xlink:href='#ref'/></a>
  <a xlink:href='#group_name' title='VARCHAR&#040; 100 &#041; not null '><text x='1078' y='1659' >group_name</text></a>
  <a xlink:href='#owner_id' title='Index  ( owner_id ) '><use id='idx' x='1066' y='1664' xlink:href='#idx'/></a>
<a xlink:href='#owner_id' title='INT not null '><text x='1078' y='1673' class='fk'>owner_id</text></a>
<a xlink:href='#owner_id' title='References student_batch ( owner_id -> student_batch_id ) References college_staff ( owner_id -> staff_id ) '><use id='fk' x='1190' y='1662' xlink:href='#fk'/></a>
  <a xlink:href='#create_date' title='DATE not null '><text x='1078' y='1687' >create_date</text></a>
  <a xlink:href='#last_update_date' title='DATE '><text x='1078' y='1701' >last_update_date</text></a>
  <a xlink:href='#capacity' title='INT '><text x='1078' y='1715' >capacity</text></a>

<!-- ============= Table 'professor_department' ============= -->
<rect class='table' x='826' y='1169' width='140' height='98' rx='7' ry='7' />
<path d='M 826.50 1190.00 L 826.50 1176.50 Q 826.50 1169.50 833.50 1169.50 L 958.50 1169.50 Q 965.50 1169.50 965.50 1176.50 L 965.50 1190.00 L826.50 1190.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#professor_department' title='college_db_schema.professor_department' ><text x='838' y='1183' class='tableTitle'>professor_department</text></a>
  <a xlink:href='#professor_id' title='Index  ( professor_id ) '><use id='idx' x='828' y='1202' xlink:href='#idx'/></a>
<a xlink:href='#professor_id' title='INT not null '><text x='840' y='1211' class='fk'>professor_id</text></a>
<a xlink:href='#professor_id' title='References college_staff ( professor_id -> staff_id ) '><use id='fk' x='952' y='1200' xlink:href='#fk'/></a>
  <a xlink:href='#department_id' title='Index  ( department_id ) '><use id='idx' x='828' y='1216' xlink:href='#idx'/></a>
<a xlink:href='#department_id' title='INT not null '><text x='840' y='1225' class='fk'>department_id</text></a>
<a xlink:href='#department_id' title='References department_details ( department_id ) '><use id='fk' x='952' y='1214' xlink:href='#fk'/></a>
  <a xlink:href='#position' title='VARCHAR&#040; 50 &#041; '><text x='840' y='1239' >position</text></a>
  <a xlink:href='#role' title='VARCHAR&#040; 100 &#041; '><text x='840' y='1253' >role</text></a>

<!-- ============= Table 'degree_current_year_semester' ============= -->
<rect class='table' x='686' y='203' width='182' height='112' rx='7' ry='7' />
<path d='M 686.50 224.00 L 686.50 210.50 Q 686.50 203.50 693.50 203.50 L 860.50 203.50 Q 867.50 203.50 867.50 210.50 L 867.50 224.00 L686.50 224.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#degree_current_year_semester' title='college_db_schema.degree_current_year_semester this will point to any semester of any batch for any degree under any department&#046; this will be useful at several places&#046; 
for eg&#046; you can find out&#058;
1&#046; what courses were offered on 3rd semester of 2004 batch for B&#046;Tech degree under DB department' ><text x='698' y='217' class='tableTitle'>degree_current_year_semester</text></a>
  <a xlink:href='#degree_department_id' title='Index  ( degree_department_id ) '><use id='idx' x='688' y='236' xlink:href='#idx'/></a>
<a xlink:href='#degree_department_id' title='INT '><text x='700' y='245' class='fk'>degree_department_id</text></a>
<a xlink:href='#degree_department_id' title='References degree_department ( degree_department_id ) '><use id='fk' x='854' y='234' xlink:href='#fk'/></a>
  <a xlink:href='#year_semester_id' title='Primary Key  ( year_semester_id ) '><use id='pk' x='688' y='250' xlink:href='#pk'/></a>
<a xlink:href='#year_semester_id' title='INT not null '><text x='700' y='259' class='pk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='Referred by degree_course ( year_semester_id ) Referred by student_course ( year_semester_id ) Referred by student_financial_semester_wise ( year_semester_id ) Referred by student_course_project ( year_semester_id ) Referred by professor_work ( year_semester_id ) Referred by professor_work ( year_semester_id ) Referred by student_result ( year_semester_id ) Referred by student_result ( year_semester_id ) '><use id='ref' x='854' y='248' xlink:href='#ref'/></a>
  <a xlink:href='#year' title='INT not null '><text x='700' y='273' >year</text></a>
  <a xlink:href='#semester' title='INT not null '><text x='700' y='287' >semester</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='700' y='301' >description</text></a>

<!-- ============= Table 'college_staff_financial' ============= -->
<rect class='table' x='518' y='441' width='140' height='126' rx='7' ry='7' />
<path d='M 518.50 462.00 L 518.50 448.50 Q 518.50 441.50 525.50 441.50 L 650.50 441.50 Q 657.50 441.50 657.50 448.50 L 657.50 462.00 L518.50 462.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#college_staff_financial' title='college_db_schema.college_staff_financial' ><text x='530' y='455' class='tableTitle'>college_staff_financial</text></a>
  <a xlink:href='#staff_id' title='Index  ( staff_id ) '><use id='idx' x='520' y='474' xlink:href='#idx'/></a>
<a xlink:href='#staff_id' title='INT not null '><text x='532' y='483' class='fk'>staff_id</text></a>
<a xlink:href='#staff_id' title='References college_staff ( staff_id ) '><use id='fk' x='644' y='472' xlink:href='#fk'/></a>
  <a xlink:href='#salary_amount' title='INT '><text x='532' y='497' >salary_amount</text></a>
  <a xlink:href='#salary_date' title='DATE '><text x='532' y='511' >salary_date</text></a>
  <a xlink:href='#payment_made' title='BOOL '><text x='532' y='525' >payment_made</text></a>
  <a xlink:href='#year' title='INT '><text x='532' y='539' >year</text></a>
  <a xlink:href='#month' title='INT '><text x='532' y='553' >month</text></a>

<!-- ============= Table 'degree_department' ============= -->
<rect class='table' x='42' y='133' width='168' height='126' rx='7' ry='7' />
<path d='M 42.50 154.00 L 42.50 140.50 Q 42.50 133.50 49.50 133.50 L 202.50 133.50 Q 209.50 133.50 209.50 140.50 L 209.50 154.00 L42.50 154.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#degree_department' title='college_db_schema.degree_department contains the mapping of department &#045; degree &#045; batch&#046; this can be used for the following for example&#058; 
1&#046; finding which departments are there in M&#046;Tech degree of 2010 batch&#046; 
2&#046; finding the degrees offered in 2011 batch of IT department
3&#046; finding the batches enrolled for B&#046;Tech degree of CS department' ><text x='75' y='147' class='tableTitle'>degree_department</text></a>
  <a xlink:href='#degree_department_id' title='Primary Key  ( degree_department_id ) '><use id='pk' x='44' y='166' xlink:href='#pk'/></a>
<a xlink:href='#degree_department_id' title='INT not null '><text x='56' y='175' class='pk'>degree_department_id</text></a>
<a xlink:href='#degree_department_id' title='Referred by student_batch ( degree_department_id ) Referred by degree_current_year_semester ( degree_department_id ) Referred by degree_current_year_semester ( degree_department_id ) '><use id='ref' x='196' y='164' xlink:href='#ref'/></a>
  <a xlink:href='#department_id' title='Index  ( department_id ) '><use id='idx' x='44' y='180' xlink:href='#idx'/></a>
<a xlink:href='#department_id' title='INT '><text x='56' y='189' class='fk'>department_id</text></a>
<a xlink:href='#department_id' title='References department_details ( department_id ) '><use id='fk' x='196' y='178' xlink:href='#fk'/></a>
  <a xlink:href='#degree_id' title='Index  ( degree_id ) '><use id='idx' x='44' y='194' xlink:href='#idx'/></a>
<a xlink:href='#degree_id' title='INT '><text x='56' y='203' class='fk'>degree_id</text></a>
<a xlink:href='#degree_id' title='References degree_details ( degree_id ) '><use id='fk' x='196' y='192' xlink:href='#fk'/></a>
  <a xlink:href='#batch_id' title='Index  ( batch_id ) '><use id='idx' x='44' y='208' xlink:href='#idx'/></a>
<a xlink:href='#batch_id' title='INT '><text x='56' y='217' class='fk'>batch_id</text></a>
<a xlink:href='#batch_id' title='References batch_details ( batch_id ) '><use id='fk' x='196' y='206' xlink:href='#fk'/></a>
  <a xlink:href='#start_year' title='INT not null '><text x='56' y='231' >start_year</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='56' y='245' >description</text></a>

<!-- ============= Table 'batch_details' ============= -->
<rect class='table' x='294' y='161' width='126' height='154' rx='7' ry='7' />
<path d='M 294.50 182.00 L 294.50 168.50 Q 294.50 161.50 301.50 161.50 L 412.50 161.50 Q 419.50 161.50 419.50 168.50 L 419.50 182.00 L294.50 182.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#batch_details' title='college_db_schema.batch_details' ><text x='322' y='175' class='tableTitle'>batch_details</text></a>
  <a xlink:href='#batch_id' title='Primary Key  ( batch_id ) '><use id='pk' x='296' y='194' xlink:href='#pk'/></a>
<a xlink:href='#batch_id' title='INT not null '><text x='308' y='203' class='pk'>batch_id</text></a>
<a xlink:href='#batch_id' title='Referred by degree_department ( batch_id ) Referred by course_management ( batch_id ) Referred by degree_management ( batch_id ) Referred by student_batch ( batch_id ) Referred by follow ( following_id -> batch_id ) Referred by follow ( following_id -> batch_id ) Referred by follow ( following_id -> batch_id ) Referred by follow ( following_id -> batch_id ) Referred by follow ( following_id -> batch_id ) '><use id='ref' x='406' y='192' xlink:href='#ref'/></a>
  <a xlink:href='#batch_name' title='VARCHAR&#040; 100 &#041; not null '><text x='308' y='217' >batch_name</text></a>
  <a xlink:href='#start_date' title='DATE not null '><text x='308' y='231' >start_date</text></a>
  <a xlink:href='#end_date' title='DATE '><text x='308' y='245' >end_date</text></a>
  <a xlink:href='#student_count' title='INT not null '><text x='308' y='259' >student_count</text></a>
  <a xlink:href='#start_year' title='INT not null '><text x='308' y='273' >start_year</text></a>
  <a xlink:href='#incharge_id' title='INT not null '><text x='308' y='287' >incharge_id</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='308' y='301' >description</text></a>

<!-- ============= Table 'degree_course' ============= -->
<rect class='table' x='280' y='343' width='140' height='112' rx='7' ry='7' />
<path d='M 280.50 364.00 L 280.50 350.50 Q 280.50 343.50 287.50 343.50 L 412.50 343.50 Q 419.50 343.50 419.50 350.50 L 419.50 364.00 L280.50 364.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#degree_course' title='college_db_schema.degree_course' ><text x='313' y='357' class='tableTitle'>degree_course</text></a>
  <a xlink:href='#degree_course_id' title='Primary Key  ( degree_course_id ) '><use id='pk' x='282' y='376' xlink:href='#pk'/></a>
<a xlink:href='#degree_course_id' title='INT not null '><text x='294' y='385' class='pk'>degree_course_id</text></a>
<a xlink:href='#degree_course_id' title='Referred by student_course ( degree_course_id ) '><use id='ref' x='406' y='374' xlink:href='#ref'/></a>
  <a xlink:href='#year_semester_id' title='Index  ( year_semester_id ) '><use id='idx' x='282' y='390' xlink:href='#idx'/></a>
<a xlink:href='#year_semester_id' title='INT '><text x='294' y='399' class='fk'>year_semester_id</text></a>
<a xlink:href='#year_semester_id' title='References degree_current_year_semester ( year_semester_id ) '><use id='fk' x='406' y='388' xlink:href='#fk'/></a>
  <a xlink:href='#course_id' title='Index  ( course_id ) '><use id='idx' x='282' y='404' xlink:href='#idx'/></a>
<a xlink:href='#course_id' title='INT '><text x='294' y='413' class='fk'>course_id</text></a>
<a xlink:href='#course_id' title='References course_details ( course_id ) '><use id='fk' x='406' y='402' xlink:href='#fk'/></a>
  <a xlink:href='#mandatory' title='BOOL not null '><text x='294' y='427' >mandatory</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='294' y='441' >description</text></a>

<!-- ============= Table 'follow' ============= -->
<rect class='table' x='742' y='427' width='140' height='98' rx='7' ry='7' />
<path d='M 742.50 448.00 L 742.50 434.50 Q 742.50 427.50 749.50 427.50 L 874.50 427.50 Q 881.50 427.50 881.50 434.50 L 881.50 448.00 L742.50 448.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#follow' title='college_db_schema.follow this is a generic table&#046; this will contain who is following what&#046; thus a follower can be any student or staff &#040;professor 
and non&#045;teaching staff&#041; and he&#047;she can be following anything&#058; colleges&#044; courses&#044; departments&#044; batches&#044; etc&#046;' ><text x='795' y='441' class='tableTitle'>follow</text></a>
  <a xlink:href='#follow_id' title='Primary Key  ( follow_id ) '><use id='pk' x='744' y='460' xlink:href='#pk'/></a>
<a xlink:href='#follow_id' title='INT not null '><text x='756' y='469' class='pk'>follow_id</text></a>
  <a xlink:href='#follower_id' title='Index  ( follower_id ) '><use id='idx' x='744' y='474' xlink:href='#idx'/></a>
<a xlink:href='#follower_id' title='INT not null '><text x='756' y='483' class='fk'>follower_id</text></a>
<a xlink:href='#follower_id' title='References student_batch ( follower_id -> student_batch_id ) References college_staff ( follower_id -> staff_id ) '><use id='fk' x='868' y='472' xlink:href='#fk'/></a>
  <a xlink:href='#following_id' title='Index  ( following_id ) '><use id='idx' x='744' y='488' xlink:href='#idx'/></a>
<a xlink:href='#following_id' title='INT not null '><text x='756' y='497' class='fk'>following_id</text></a>
<a xlink:href='#following_id' title='References batch_details ( following_id -> batch_id ) References department_details ( following_id -> department_id ) References degree_details ( following_id -> degree_id ) References course_details ( following_id -> course_id ) References student_batch ( following_id -> student_batch_id ) References student_batch ( following_id -> student_batch_id ) '><use id='fk' x='868' y='486' xlink:href='#fk'/></a>
  <a xlink:href='#follow_start_date' title='DATE '><text x='756' y='511' >follow_start_date</text></a>

<!-- ============= Table 'connections' ============= -->
<rect class='table' x='1022' y='203' width='168' height='112' rx='7' ry='7' />
<path d='M 1022.50 224.00 L 1022.50 210.50 Q 1022.50 203.50 1029.50 203.50 L 1182.50 203.50 Q 1189.50 203.50 1189.50 210.50 L 1189.50 224.00 L1022.50 224.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#connections' title='college_db_schema.connections' ><text x='1074' y='217' class='tableTitle'>connections</text></a>
  <a xlink:href='#user_connection_id' title='Primary Key  ( user_connection_id ) '><use id='pk' x='1024' y='236' xlink:href='#pk'/></a>
<a xlink:href='#user_connection_id' title='INT not null '><text x='1036' y='245' class='fk'>user_connection_id</text></a>
<a xlink:href='#user_connection_id' title='References college_staff ( user_connection_id -> staff_id ) '><use id='fk' x='1176' y='234' xlink:href='#fk'/></a>
  <a xlink:href='#user_id' title='Index  ( user_id ) '><use id='idx' x='1024' y='250' xlink:href='#idx'/></a>
<a xlink:href='#user_id' title='INT not null '><text x='1036' y='259' class='fk'>user_id</text></a>
<a xlink:href='#user_id' title='References student_batch ( user_id -> student_batch_id ) References college_staff ( user_id -> staff_id ) '><use id='fk' x='1176' y='248' xlink:href='#fk'/></a>
  <a xlink:href='#connection_id' title='INT not null '><text x='1036' y='273' class='fk'>connection_id</text></a>
<a xlink:href='#connection_id' title='References student_batch ( connection_id -> student_batch_id ) '><use id='fk' x='1176' y='262' xlink:href='#fk'/></a>
  <a xlink:href='#connection_start_date' title='DATE not null '><text x='1036' y='287' >connection_start_date</text></a>
  <a xlink:href='#connection_type' title='VARCHAR&#040; 100 &#041; '><text x='1036' y='301' >connection_type</text></a>

<!-- ============= Table 'department_details' ============= -->
<rect class='table' x='42' y='357' width='140' height='98' rx='7' ry='7' />
<path d='M 42.50 378.00 L 42.50 364.50 Q 42.50 357.50 49.50 357.50 L 174.50 357.50 Q 181.50 357.50 181.50 364.50 L 181.50 378.00 L42.50 378.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#department_details' title='college_db_schema.department_details' ><text x='61' y='371' class='tableTitle'>department_details</text></a>
  <a xlink:href='#department_id' title='Primary Key  ( department_id ) '><use id='pk' x='44' y='390' xlink:href='#pk'/></a>
<a xlink:href='#department_id' title='INT not null '><text x='56' y='399' class='pk'>department_id</text></a>
<a xlink:href='#department_id' title='Referred by course_details ( department_id ) Referred by degree_department ( department_id ) Referred by follow ( following_id -> department_id ) Referred by follow ( following_id -> department_id ) Referred by follow ( following_id -> department_id ) Referred by professor_details ( department_id ) Referred by professor_department ( department_id ) '><use id='ref' x='168' y='388' xlink:href='#ref'/></a>
  <a xlink:href='#department_name' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='413' >department_name</text></a>
  <a xlink:href='#start_year' title='INT not null '><text x='56' y='427' >start_year</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='56' y='441' >description</text></a>

<!-- ============= Table 'degree_details' ============= -->
<rect class='table' x='42' y='469' width='140' height='140' rx='7' ry='7' />
<path d='M 42.50 490.00 L 42.50 476.50 Q 42.50 469.50 49.50 469.50 L 174.50 469.50 Q 181.50 469.50 181.50 476.50 L 181.50 490.00 L42.50 490.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#degree_details' title='college_db_schema.degree_details' ><text x='74' y='483' class='tableTitle'>degree_details</text></a>
  <a xlink:href='#degree_id' title='Primary Key  ( degree_id ) '><use id='pk' x='44' y='502' xlink:href='#pk'/></a>
<a xlink:href='#degree_id' title='INT not null '><text x='56' y='511' class='pk'>degree_id</text></a>
<a xlink:href='#degree_id' title='Referred by degree_department ( degree_id ) Referred by degree_management ( degree_id ) Referred by follow ( following_id -> degree_id ) Referred by follow ( following_id -> degree_id ) Referred by follow ( following_id -> degree_id ) Referred by follow ( following_id -> degree_id ) Referred by follow ( following_id -> degree_id ) '><use id='ref' x='168' y='500' xlink:href='#ref'/></a>
  <a xlink:href='#degree_name' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='525' >degree_name</text></a>
  <a xlink:href='#duration' title='INT '><text x='56' y='539' >duration</text></a>
  <a xlink:href='#start_year' title='INT not null '><text x='56' y='553' >start_year</text></a>
  <a xlink:href='#prerequisite' title='VARCHAR&#040; 100 &#041; '><text x='56' y='567' >prerequisite</text></a>
  <a xlink:href='#last_update_date' title='DATE '><text x='56' y='581' >last_update_date</text></a>
  <a xlink:href='#description' title='VARCHAR&#040; 200 &#041; '><text x='56' y='595' >description</text></a>

<!-- ============= Table 'course_details' ============= -->
<rect class='table' x='42' y='623' width='126' height='154' rx='7' ry='7' />
<path d='M 42.50 644.00 L 42.50 630.50 Q 42.50 623.50 49.50 623.50 L 160.50 623.50 Q 167.50 623.50 167.50 630.50 L 167.50 644.00 L42.50 644.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#course_details' title='college_db_schema.course_details' ><text x='68' y='637' class='tableTitle'>course_details</text></a>
  <a xlink:href='#course_id' title='Primary Key  ( course_id ) '><use id='pk' x='44' y='656' xlink:href='#pk'/></a>
<a xlink:href='#course_id' title='INT not null '><text x='56' y='665' class='pk'>course_id</text></a>
<a xlink:href='#course_id' title='Referred by degree_course ( course_id ) Referred by course_management ( course_id ) Referred by follow ( following_id -> course_id ) Referred by follow ( following_id -> course_id ) Referred by follow ( following_id -> course_id ) Referred by course_professor ( course_id ) Referred by course_professor ( course_id ) Referred by professor_work ( course_id ) Referred by professor_work ( course_id ) '><use id='ref' x='154' y='654' xlink:href='#ref'/></a>
  <a xlink:href='#course_name' title='VARCHAR&#040; 100 &#041; not null '><text x='56' y='679' >course_name</text></a>
  <a xlink:href='#duration' title='INT '><text x='56' y='693' >duration</text></a>
  <a xlink:href='#credit' title='INT not null '><text x='56' y='707' >credit</text></a>
  <a xlink:href='#lab' title='BOOL not null '><text x='56' y='721' >lab</text></a>
  <a xlink:href='#theory' title='BOOL not null '><text x='56' y='735' >theory</text></a>
  <a xlink:href='#start_year' title='INT not null '><text x='56' y='749' >start_year</text></a>
  <a xlink:href='#department_id' title='Index  ( department_id ) '><use id='idx' x='44' y='754' xlink:href='#idx'/></a>
<a xlink:href='#department_id' title='INT '><text x='56' y='763' class='fk'>department_id</text></a>
<a xlink:href='#department_id' title='References department_details ( department_id ) '><use id='fk' x='154' y='752' xlink:href='#fk'/></a>

<!-- ============= Table 'posts' ============= -->
<rect class='table' x='728' y='1883' width='112' height='98' rx='7' ry='7' />
<path d='M 728.50 1904.00 L 728.50 1890.50 Q 728.50 1883.50 735.50 1883.50 L 832.50 1883.50 Q 839.50 1883.50 839.50 1890.50 L 839.50 1904.00 L728.50 1904.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#posts' title='college_db_schema.posts' ><text x='770' y='1897' class='tableTitle'>posts</text></a>
  <a xlink:href='#post_id' title='Primary Key  ( post_id ) '><use id='pk' x='730' y='1916' xlink:href='#pk'/></a>
<a xlink:href='#post_id' title='INT not null '><text x='742' y='1925' class='pk'>post_id</text></a>
  <a xlink:href='#posted_by_id' title='Index  ( posted_by_id ) '><use id='idx' x='730' y='1930' xlink:href='#idx'/></a>
<a xlink:href='#posted_by_id' title='INT not null '><text x='742' y='1939' class='fk'>posted_by_id</text></a>
<a xlink:href='#posted_by_id' title='References student_batch ( posted_by_id -> student_batch_id ) References college_staff ( posted_by_id -> staff_id ) '><use id='fk' x='826' y='1928' xlink:href='#fk'/></a>
  <a xlink:href='#post date' title='DATE '><text x='742' y='1953' >post date</text></a>
  <a xlink:href='#post_content' title='VARCHAR&#040; 1000 &#041; not null '><text x='742' y='1967' >post_content</text></a>

<!-- ============= Table 'message' ============= -->
<rect class='table' x='1078' y='1841' width='126' height='126' rx='7' ry='7' />
<path d='M 1078.50 1862.00 L 1078.50 1848.50 Q 1078.50 1841.50 1085.50 1841.50 L 1196.50 1841.50 Q 1203.50 1841.50 1203.50 1848.50 L 1203.50 1862.00 L1078.50 1862.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#message' title='college_db_schema.message' ><text x='1119' y='1855' class='tableTitle'>message</text></a>
  <a xlink:href='#message_id' title='Primary Key  ( message_id ) '><use id='pk' x='1080' y='1874' xlink:href='#pk'/></a>
<a xlink:href='#message_id' title='INT not null '><text x='1092' y='1883' class='pk'>message_id</text></a>
  <a xlink:href='#sender_id' title='Index  ( sender_id ) '><use id='idx' x='1080' y='1888' xlink:href='#idx'/></a>
<a xlink:href='#sender_id' title='INT not null '><text x='1092' y='1897' class='fk'>sender_id</text></a>
<a xlink:href='#sender_id' title='References student_batch ( sender_id -> student_batch_id ) References college_staff ( sender_id -> staff_id ) '><use id='fk' x='1190' y='1886' xlink:href='#fk'/></a>
  <a xlink:href='#receiver_id' title='Index  ( receiver_id ) '><use id='idx' x='1080' y='1902' xlink:href='#idx'/></a>
<a xlink:href='#receiver_id' title='INT not null '><text x='1092' y='1911' class='fk'>receiver_id</text></a>
<a xlink:href='#receiver_id' title='References student_batch ( receiver_id -> student_batch_id ) References college_staff ( receiver_id -> staff_id ) '><use id='fk' x='1190' y='1900' xlink:href='#fk'/></a>
  <a xlink:href='#body' title='VARCHAR&#040; 5000 &#041; '><text x='1092' y='1925' >body</text></a>
  <a xlink:href='#subject' title='VARCHAR&#040; 1000 &#041; '><text x='1092' y='1939' >subject</text></a>
  <a xlink:href='#attachment_id' title='Index  ( attachment_id ) '><use id='idx' x='1080' y='1944' xlink:href='#idx'/></a>
<a xlink:href='#attachment_id' title='INT '><text x='1092' y='1953' class='fk'>attachment_id</text></a>
<a xlink:href='#attachment_id' title='References document_upload ( attachment_id -> document_id ) '><use id='fk' x='1190' y='1942' xlink:href='#fk'/></a>

<!-- ============= Callout ============= -->
<rect class='callout' x='518' y='1792' width='448' height='65' rx='14' ry='14'  />
<text x='532' y='1799'>
    <tspan x='518' dx='10' dy='16'>this will map all the documents uploaded with the uploader id&#046; for example&#044;</tspan>
    <tspan x='518' dx='10' dy='16'>if a student uploads a document in DB course&#044; then that document entry will</tspan>
    <tspan x='518' dx='10' dy='16'>first be stored in this table&#044; then it will be used everywhere using this document&#095;id</tspan>
</text>
<rect style='fill:url(#hintPointerSV);stroke:none;' x='532' y='1857' width='13' height='13'/>

<!-- ============= Callout ============= -->
<rect class='callout' x='882' y='420' width='616' height='48' rx='14' ry='14'  />
<text x='896' y='427'>
    <tspan x='882' dx='10' dy='16'>this is a generic table&#046; this will contain who is following what&#046; thus a follower can be any student or staff &#040;professor </tspan>
    <tspan x='882' dx='10' dy='16'>and non&#045;teaching staff&#041; and he&#047;she can be following anything&#058; colleges&#044; courses&#044; departments&#044; batches&#044; etc&#046;</tspan>
</text>
<rect style='fill:url(#hintPointerSV);stroke:none;' x='896' y='468' width='13' height='13'/>

<!-- ============= Callout ============= -->
<rect class='callout' x='868' y='140' width='630' height='65' rx='14' ry='14'  />
<text x='882' y='147'>
    <tspan x='868' dx='10' dy='16'>this will point to any semester of any batch for any degree under any department&#046; this will be useful at several places&#046; </tspan>
    <tspan x='868' dx='10' dy='16'>for eg&#046; you can find out&#058;</tspan>
    <tspan x='868' dx='10' dy='16'>1&#046; what courses were offered on 3rd semester of 2004 batch for B&#046;Tech degree under DB department</tspan>
</text>
<rect style='fill:url(#hintPointerSV);stroke:none;' x='882' y='205' width='13' height='13'/>

<!-- ============= Callout ============= -->
<rect class='callout' x='84' y='42' width='546' height='82' rx='14' ry='14'  />
<text x='98' y='49'>
    <tspan x='84' dx='10' dy='16'>contains the mapping of department &#045; degree &#045; batch&#046; this can be used for the following for example&#058; </tspan>
    <tspan x='84' dx='10' dy='16'>1&#046; finding which departments are there in M&#046;Tech degree of 2010 batch&#046; </tspan>
    <tspan x='84' dx='10' dy='16'>2&#046; finding the degrees offered in 2011 batch of IT department</tspan>
    <tspan x='84' dx='10' dy='16'>3&#046; finding the batches enrolled for B&#046;Tech degree of CS department</tspan>
</text>
<rect style='fill:url(#hintPointerSV);stroke:none;' x='98' y='124' width='13' height='13'/>

</g></svg>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='batch_details'>batch_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_name'>batch&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_count'>student&#095;count</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_id'>incharge&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;batch primary key</td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_residential'>college_residential</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='residential_id'>residential&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_name'>residential&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_type'>residential&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='warden_id'>warden&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='warden_name'>warden&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;residential primary key</td>
		<td> ( residential&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_staff'>college_staff</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='staff_id'>staff&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='staff_name'>staff&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='designation'>designation</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='joining_date'>joining&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='phone_number'>phone&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line'>address&#095;line</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='city'>city</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='state'>state</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='country'>country</a></td>
		<td width='40%'> VARCHAR&#040; 30 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='email_id'>email&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='staff_type'>staff&#095;type</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='role'>role</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;staff primary key</td>
		<td> ( staff&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_staff_financial'>college_staff_financial</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='staff_id'>staff&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='salary_amount'>salary&#095;amount</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='salary_date'>salary&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='payment_made'>payment&#095;made</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year'>year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='month'>month</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;college&#095;staff&#095;financial </td>
		<td> ( staff&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_college_staff_financial</td>
		<td > (  staff&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='connections'>connections</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='user_connection_id'>user&#095;connection&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='user_id'>user&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_id'>connection&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_start_date'>connection&#095;start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_type'>connection&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;connections primary key</td>
		<td> ( user&#095;connection&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;connections </td>
		<td> ( user&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_connections_user_id_type_1</td>
		<td > (  user&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_connection_id_type_1</td>
		<td > (  user&#095;connection&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_user_id_type_2</td>
		<td > (  user&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_connection_id_type_2</td>
		<td > (  connection&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_details'>course_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_name'>course&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='duration'>duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='credit'>credit</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='lab'>lab</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='theory'>theory</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;course&#095;details primary key</td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;details </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_details</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_management'>course_management</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='prerequisite'>prerequisite</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_exams'>total&#095;exams</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;course&#095;management </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;management </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_management_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_management_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_professor'>course_professor</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_professor_id'>course&#095;professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_1'>professor&#095;id&#095;1</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_2'>professor&#095;id&#095;2</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_3'>professor&#095;id&#095;3</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_4'>professor&#095;id&#095;4</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='lecture_duration'>lecture&#095;duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='status'>status</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visiting_id'>visiting&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;course&#095;professor primary key</td>
		<td> ( course&#095;professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;1) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;2) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;3) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;4) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( visiting&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_professor_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_1</td>
		<td > (  professor&#095;id&#095;1  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_2</td>
		<td > (  professor&#095;id&#095;2  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_3</td>
		<td > (  professor&#095;id&#095;3  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_4</td>
		<td > (  professor&#095;id&#095;4  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_visiting_id</td>
		<td > (  visiting&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_course'>degree_course</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_course_id'>degree&#095;course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mandatory'>mandatory</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;course primary key</td>
		<td> ( degree&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;course </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;course </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_course_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_current_year_semester'>degree_current_year_semester</a></th></tr>
<tr><td colspan='3'>this will point to any semester of any batch for any degree under any department&#046; this will be useful at several places&#046; 
for eg&#046; you can find out&#058;
1&#046; what courses were offered on 3rd semester of 2004 batch for B&#046;Tech degree under DB department </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year'>year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='semester'>semester</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;current&#095;year&#095;semester primary key</td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;current&#095;year&#095;semester </td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_current_year_semester_degree_department_id</td>
		<td > (  degree&#095;department&#095;id  ) ref <a href='#degree&#095;department'>degree&#095;department</a> ( degree&#095;department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_department'>degree_department</a></th></tr>
<tr><td colspan='3'>contains the mapping of department &#045; degree &#045; batch&#046; this can be used for the following for example&#058; 
1&#046; finding which departments are there in M&#046;Tech degree of 2010 batch&#046; 
2&#046; finding the degrees offered in 2011 batch of IT department
3&#046; finding the batches enrolled for B&#046;Tech degree of CS department </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;department primary key</td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_department_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_department_department_id</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_department_degree_id</td>
		<td > (  degree&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_details'>degree_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_name'>degree&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='duration'>duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='prerequisite'>prerequisite</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update_date'>last&#095;update&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;details primary key</td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_management'>degree_management</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_incharge_id'>degree&#095;incharge&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_start_date'>incharge&#095;start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_end_date'>incharge&#095;end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;degree&#095;management </td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;management </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_management_degree_id</td>
		<td > (  degree&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_management_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='department_details'>department_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_name'>department&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;department&#095;details primary key</td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='document_upload'>document_upload</a></th></tr>
<tr><td colspan='3'>this will map all the documents uploaded with the uploader id&#046; for example&#044;
if a student uploads a document in DB course&#044; then that document entry will
first be stored in this table&#044; then it will be used everywhere using this document&#095;id </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='document_id'>document&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='uploader_id'>uploader&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='document_name'>document&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='upload_date'>upload&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;document&#095;upload primary key</td>
		<td> ( document&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;document&#095;upload </td>
		<td> ( uploader&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_document_upload_uploader_id_type_1</td>
		<td > (  uploader&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_document_upload_uploader_id_type_2</td>
		<td > (  uploader&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='follow'>follow</a></th></tr>
<tr><td colspan='3'>this is a generic table&#046; this will contain who is following what&#046; thus a follower can be any student or staff &#040;professor 
and non&#045;teaching staff&#041; and he&#047;she can be following anything&#058; colleges&#044; courses&#044; departments&#044; batches&#044; etc&#046; </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='follow_id'>follow&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='follower_id'>follower&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='following_id'>following&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='follow_start_date'>follow&#095;start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;follow primary key</td>
		<td> ( follow&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;follow </td>
		<td> ( follower&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;follow </td>
		<td> ( following&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_follow_follower_id_type_1</td>
		<td > (  follower&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_1</td>
		<td > (  following&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_2</td>
		<td > (  following&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_folllowing_id_type_3</td>
		<td > (  following&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_4</td>
		<td > (  following&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_5</td>
		<td > (  following&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_6</td>
		<td > (  following&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_college_staff</td>
		<td > (  follower&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group'>group</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='group_name'>group&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='owner_id'>owner&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='create_date'>create&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update_date'>last&#095;update&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;group primary key</td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group </td>
		<td> ( owner&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_owner_id_type_1</td>
		<td > (  owner&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_owner_id_type_2</td>
		<td > (  owner&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group_member'>group_member</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='member_id'>member&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='add_date'>add&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='leave_date'>leave&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update)date'>last&#095;update&#041;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='added_by_id'>added&#095;by&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;group&#095;member unique</td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;member </td>
		<td> ( member&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;member </td>
		<td> ( added&#095;by&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_member_group</td>
		<td > (  group&#095;id  ) ref <a href='#group'>group</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_member_id_type_1</td>
		<td > (  member&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_member_id_type_2</td>
		<td > (  member&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_added_by_id_type_1</td>
		<td > (  added&#095;by&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_added_by_id_type_2</td>
		<td > (  added&#095;by&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group_update'>group_update</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='update_id'>update&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='member_id'>member&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='parent_update_id'>parent&#095;update&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='document_id'>document&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( member&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( document&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_update_group_id</td>
		<td > (  group&#095;id  ) ref <a href='#group'>group</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_update_member_id</td>
		<td > (  member&#095;id  ) ref <a href='#group&#095;member'>group&#095;member</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_update_document_id</td>
		<td > (  document&#095;id  ) ref <a href='#document&#095;upload'>document&#095;upload</a> ( document&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='library_book_details'>library_book_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='book_id'>book&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='author_name'>author&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='book_name'>book&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='category'>category</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='price'>price</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='publisher'>publisher</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='referred_by'>referred&#095;by</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;library&#095;book&#095;details primary key</td>
		<td> ( book&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='login_info'>login_info</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='login_id'>login&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='password'>password</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='college_id'>college&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_login_time'>last&#095;login&#095;time</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_password_update_time'>last&#095;password&#095;update&#095;time</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='security_question'>security&#095;question</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='security_question_answer'>security&#095;question&#095;answer</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='user_type'>user&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 30 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;login&#095;info </td>
		<td> ( login&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_login_info_student_details</td>
		<td > (  login&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( email&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='message'>message</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='message_id'>message&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='sender_id'>sender&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='receiver_id'>receiver&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='body'>body</a></td>
		<td width='40%'> VARCHAR&#040; 5000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='subject'>subject</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='attachment_id'>attachment&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;message primary key</td>
		<td> ( message&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( sender&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( receiver&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( attachment&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_message_sender_id_type_1</td>
		<td > (  sender&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_sender_id_type_2</td>
		<td > (  sender&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_receiver_id_type_1</td>
		<td > (  receiver&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message__receiver_id_type_2</td>
		<td > (  receiver&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_attachment_id</td>
		<td > (  attachment&#095;id  ) ref <a href='#document&#095;upload'>document&#095;upload</a> ( document&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='placements'>placements</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='company_id'>company&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='company_name'>company&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visit_date'>visit&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visit_time'>visit&#095;time</a></td>
		<td width='40%'> TIME     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='internship'>internship</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='regular'>regular</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='package_offered'>package&#095;offered</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='job_description'>job&#095;description</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_placed_count'>student&#095;placed&#095;count</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;placements primary key</td>
		<td> ( company&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;placements </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_placements_student_batch</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='posts'>posts</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='post_id'>post&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='posted_by_id'>posted&#095;by&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='post date'>post date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='post_content'>post&#095;content</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;posts primary key</td>
		<td> ( post&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;posts </td>
		<td> ( posted&#095;by&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_posts_posted_by_id_type_1</td>
		<td > (  posted&#095;by&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_posts_posted_by_id_type_2</td>
		<td > (  posted&#095;by&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='professor_department'>professor_department</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='position'>position</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='role'>role</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;professor&#095;details </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;details </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_professor_details_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_details</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='professor_work'>professor_work</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='patent'>patent</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='research'>research</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='project'>project</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_professor_work_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_work_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_work</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='residential_room'>residential_room</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='room_id'>room&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_id'>residential&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='room_number'>room&#095;number</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='vacancy'>vacancy</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='occupancy'>occupancy</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;residential&#095;room </td>
		<td> ( residential&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;residential&#095;room primary key</td>
		<td> ( room&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_residential_room_residential_id</td>
		<td > (  residential&#095;id  ) ref <a href='#college&#095;residential'>college&#095;residential</a> ( residential&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_batch'>student_batch</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_year'>end&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='room_id'>room&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;batch primary key</td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch&#095;0 </td>
		<td> ( room&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_batch_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_department_degree_id</td>
		<td > (  degree&#095;department&#095;id  ) ref <a href='#degree&#095;department'>degree&#095;department</a> ( degree&#095;department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_room_id</td>
		<td > (  room&#095;id  ) ref <a href='#residential&#095;room'>residential&#095;room</a> ( room&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_book_borrow'>student_book_borrow</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='borrower_id'>borrower&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='book_id'>book&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='issue_date'>issue&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='return_date'>return&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='borrower_type'>borrower&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;book&#095;borrow </td>
		<td> ( book&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;book&#095;borrow </td>
		<td> ( borrower&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_book_borrow_book_id</td>
		<td > (  book&#095;id  ) ref <a href='#library&#095;book&#095;details'>library&#095;book&#095;details</a> ( book&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_book_borrow_borrower_id</td>
		<td > (  borrower&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_course'>student_course</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_course_id'>student&#095;course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_course_id'>degree&#095;course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='marks'>marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='grade'>grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;course </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course </td>
		<td> ( degree&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;0 </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;course primary key</td>
		<td> ( student&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_course_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_degree_course_id</td>
		<td > (  degree&#095;course&#095;id  ) ref <a href='#degree&#095;course'>degree&#095;course</a> ( degree&#095;course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_course_project'>student_course_project</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_project_id'>course&#095;project&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_project_name'>course&#095;project&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_course_id'>student&#095;course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='abstract'>abstract</a></td>
		<td width='40%'> VARCHAR&#040; 500 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='recognition'>recognition</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='technology_used'>technology&#095;used</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='skill_used'>skill&#095;used</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;course&#095;project primary key</td>
		<td> ( course&#095;project&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project </td>
		<td> ( student&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project&#095;0 </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project&#095;1 </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_course_project_student_course_id</td>
		<td > (  student&#095;course&#095;id  ) ref <a href='#student&#095;course'>student&#095;course</a> ( student&#095;course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_project</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_project_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_details'>student_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_name'>student&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='roll_number'>roll&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='registration_number'>registration&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mobile_number'>mobile&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='phone_number'>phone&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line_1'>address&#095;line&#095;1</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line_2'>address&#095;line&#095;2</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='city'>city</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='state'>state</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='country'>country</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='email_id'>email&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='date_of_birth'>date&#095;of&#095;birth</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree'>highest&#095;degree</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_marks'>highest&#095;degree&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_college_name'>highest&#095;degree&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_passout_year'>highest&#095;degree&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1'>previous&#095;degree&#095;1</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_marks'>previous&#095;degree&#095;1&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_college_name'>previous&#095;degree&#095;1&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_passout_year'>previous&#095;degree&#095;1&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2'>previous&#095;degree&#095;2</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_marks'>previous&#095;degree&#095;2&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_college_name'>previous&#095;degree&#095;2&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_passout_year'>previous&#095;degree&#095;2&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='years_of_experience'>years&#095;of&#095;experience</a></td>
		<td width='40%'> FLOAT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='gender'>gender</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='father_name'>father&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='pan_card_number'>pan&#095;card&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='passport_number'>passport&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='passport_expiry_date'>passport&#095;expiry&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;details primary key</td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;details&#095;0 unique</td>
		<td> ( email&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_finance_one_time'>student_finance_one_time</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='caution_fee'>caution&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='admission_fee'>admission&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='other_fee'>other&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_payment'>total&#095;payment</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;finance&#095;one&#095;time </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_finance_one_time_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_financial_semester_wise'>student_financial_semester_wise</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='tuition_fee'>tuition&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='library_fee'>library&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='hostel_fee'>hostel&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mess_fee'>mess&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='other_fee'>other&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_payment'>total&#095;payment</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='payment_date'>payment&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='receipt_number'>receipt&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;financial&#095;semester&#095;wise </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;financial&#095;semester&#095;wise </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_financial_semester_wise_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_financial_semester_wise_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_placed'>student_placed</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='company_id'>company&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='internship'>internship</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='regular'>regular</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;placed </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_placed_company__id</td>
		<td > (  company&#095;id  ) ref <a href='#placements'>placements</a> ( company&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_placed_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_profile_picture'>student_profile_picture</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='user_id'>user&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='profile_picture'>profile&#095;picture</a></td>
		<td width='40%'> BLOB     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;profile&#095;picture </td>
		<td> ( user&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_profile_picture_user_id</td>
		<td > (  user&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_result'>student_result</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_professor_id'>course&#095;professor&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='final_grade'>final&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='attendance'>attendance</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='theory_grade'>theory&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='practical_grade'>practical&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='result'>result</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( course&#095;professor&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_result_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_result_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_result_course_professor_id</td>
		<td > (  course&#095;professor&#095;id  ) ref <a href='#course&#095;professor'>course&#095;professor</a> ( course&#095;professor&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_resume'>student_resume</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='resume_id'>resume&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='title'>title</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='url'>url</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='most_recent'>most&#095;recent</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='upload_date'>upload&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;resume primary key</td>
		<td> ( resume&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;resume </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_resume_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

</body></html>